#1
  1. A Change of Season
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    2,681
    Rep Power
    171

    Local host phpmyadmin delays


    Hi;
    I am using on localhost where everything is fast and no one pays tax. I paste the query in text box on phpmyadmin to execute:
    Code:
    SELECT id
    FROM products_table
    WHERE price =35
    LIMIT 0 , 30
    It takes about 10 seconds for phpmyadmin to show the results:
    But the message says:
    Showing rows 0 - 29 (~5,005,2441 total, Query took 0.0007 sec)
    Why does it take 10 seconds and not 0.0007? Why does it take 10 seconds to load?

    Thanks
    ---------------------

    (The table has 10 million records and not indexed on purpose (just practising indexes)).
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2004
    Location
    Kurvi
    Posts
    490
    Rep Power
    185
    I tried something similar on command line. The reason _could be_ the part that is highlighted.

    Originally Posted by zxcvbnm
    But the message says:
    Showing rows 0 - 29 (~5,005,2441 total, Query took 0.0007 sec)
    Try on command line:
    Code:
    SELECT id
    FROM products_table
    WHERE price =35
    LIMIT 0 , 30
    vs.

    Code:
    SELECT id, count(*)
    FROM products_table
    WHERE price =35
    LIMIT 0 , 30
    Gabba Gabba Hey

IMN logo majestic logo threadwatch logo seochat tools logo