DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Posts
    1

    fast query execution

    Hi

    DB: MySql

    Is there anything for making the search fast in mysql? like indexing in MSSql Server. I want to make the search function fast.
    The few options that i have at the moement are:

    stored procedures
    Mysql Cache
    Indexing

    need to some good ideas

    thanks in advance

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

Similar Threads

  1. SQL2000 remote SQL query
    By lightningtechie in forum Database
    Replies: 1
    Last Post: 02-07-2006, 08:34 AM
  2. Slow first execution (then fast)
    By pep_castefa in forum Database
    Replies: 5
    Last Post: 02-17-2005, 03:54 AM
  3. Replies: 0
    Last Post: 08-05-2002, 08:52 AM
  4. Query Execution
    By Steven in forum Database
    Replies: 0
    Last Post: 02-02-2002, 11:28 AM
  5. Analysis of Query Execution Plan
    By Vladimir in forum Database
    Replies: 0
    Last Post: 05-26-2000, 03:51 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


Top DevX Stories

Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL


Sponsored Links