MySQL Forums
Forum List  »  Performance

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?
2129
November 21, 2011 04:08PM
813
November 22, 2011 09:01PM
696
November 24, 2011 03:47PM
1014
November 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.