MySQL Forums :: Performance :: Expected query time?


Advanced Search

Expected query time?
Posted by: Joachim Andersen ()
Date: November 21, 2011 04:08PM

Hello,

I have a table set up like this:
Field--------Type---------------Null--------Key-----Default-----Extra
ID-----------int(10) unsigned---NO----------PRI-----NULL--------auto_increment
serial-------varchar(32)--------NO----------UNI-----NULL----
name---------text---------------NO---- -------------NULL----
playTime-----bigint(20)unsigned-NO---- -------------NULL----
points-------int(10) unsigned---NO---- -------------NULL

Example, record one:
1----RD6FBDD394N5YY9THN426Y34M9I8R11H----kfr9----0----83

The total amount of entries is 99,974

Doing a simple
SELECT * FROM `accounts` LIMIT 0, 30

takes 0.0007 sec., however if I wait a bit and don't use the table, it will sometimes take up to 0.006 sec.

I am testing this via phpmyadmin on my computer running XAMPP. The server version will have data similar to that (eventually same amount of records and same sorts of data).

Is this execution time normal for a table set up like that? Is it poorly set up?

SELECT * 
FROM  `accounts` 
WHERE  `ID` =48928
LIMIT 0 , 30
This code took 0.0279 sec to execute. Isn't that a bit slow for a fairly small table using primary index?



Edited 2 time(s). Last edit at 11/21/2011 04:10PM by Joachim Andersen.

Options: ReplyQuote


Subject Views Written By Posted
Expected query time? 2039 Joachim Andersen 11/21/2011 04:08PM
Re: Expected query time? 757 Rick James 11/22/2011 09:01PM
Re: Expected query time? 658 Joachim Andersen 11/24/2011 03:47PM
Re: Expected query time? 892 Rick James 11/25/2011 01:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.