Wednesday, April 18, 2012

Acceptable mysql select speed as per documentation?

Is there an acceptable speed as in this many records per second for MySQL SELECT? I know it depends on how complex the query is and my machine spec. But can I have a vague/approximate speed estimation of a standard SELECT query? May be for something like this:



SELECT a, b, c, d, e, f FROM my_table;


I use .NET connector to access MySQL; from my code I do something like this:



MySqlCommand cmd = new MySqlCommand(query, _conn);
MySqlDataReader r = cmd.ExecuteReader();

List<int> lst = new List<int>();
while (r.Read())
{
lst.Add(.....
}

r.Close();


Currently I can SELECT 25000 records under 150 ms. But when I run it under phpmyadmin it takes about 75 ms. From MySQL console it neeed 110 ms. Is there a need not be worried about limit that documentation recommends be it via connector, console or anything? I am running on an Intel Core2 Duo (2 GHz) with 2 Gb RAM. Speed is critical for my need.



I remember reading one such somewhere..





No comments:

Post a Comment