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.