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