chong
09-21-2006, 03:09 AM
Hi, i'm running queries to generate a table on library data, on approx. 2 million records and higher
The select query is simply a conjunction of clauses based on several constraints such as publication year of the books and its location.
However, when running it from php running local to the MySql server, it seems to take forever to query (well, about 10 mins, to be more accurate).
Inspecting taskmanager on the server shows that mysqld-nt.exe uses only like 1 to 2 % of the CPU cycle most of the time.
What could possibly be the cause of the delay?
The select query is simply a conjunction of clauses based on several constraints such as publication year of the books and its location.
However, when running it from php running local to the MySql server, it seems to take forever to query (well, about 10 mins, to be more accurate).
Inspecting taskmanager on the server shows that mysqld-nt.exe uses only like 1 to 2 % of the CPU cycle most of the time.
What could possibly be the cause of the delay?