Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004

    Unanswered: mySQL access-time


    I want to set up a mySQL Table with 5 million entries. How long will it take in average to search one of those entries.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    The ever popular "it depends" is the best I can do. How are you doing your query, is it indexed (and can the query use them), what kind of hardware are you running, etc? Way more questions than answers, but I'd guess you are looking at about 3 seconds if you do it right.


  3. #3
    Join Date
    Mar 2004
    So could you please check this out:

    I have queries running for more then 20 sec on a 500,000 records table...


  4. #4
    Join Date
    Oct 2003
    If your queries are taking several seconds, then almost certainly you are doing full-table scans. Or you may be using subqueries that are being executed hundreds or thousands of times.

    The EXPLAIN verb is useful for showing you the "execution plan" that has been derived from your query. The execution-plan is the actual 'program' that is executed by the DBMS to produce the results you seek. If the operation is going to be expensive, you'll see it right there.
    ChimneySweep(R): fast, automatic
    table repair at a click of the

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts