MySQL Forums
Forum List  »  Performance

Re: 30,000 MySQL queries...
Posted by: Benoit St-Jean
Date: September 25, 2005 03:16PM

Is most of the execution time spent in MySQL or your program takes a lot of time building the strings used for the SQL query? Do you use one persistent connection or you reconnect each and every time? Have your tried building the strings, put them in a file and execute that huge script from the MySQL console (or command prompt with the script redirected) to see how much time it takes?

Options: ReplyQuote


Subject
Views
Written By
Posted
2085
September 16, 2005 07:24AM
1341
September 16, 2005 08:37AM
1407
September 16, 2005 03:23PM
1292
September 17, 2005 06:49PM
Re: 30,000 MySQL queries...
1431
September 25, 2005 03:16PM
1361
September 29, 2005 02:21PM


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.