A decent RDBMS should provide the developer with a query analyser which displays how the query will be compiled and give an estimate of execution time in each part so you can investigate where most of the power is drained.
By the way, your question is rather not that much about php. (Not that I uses php and care that much... :) -----Original Message----- From: Arnout van der Kamp To: [EMAIL PROTECTED] Sent: 2001-11-15 01:21 Subject: [PHP-WIN] Speed of SQL queries, profiling? I've written some code to extract a database from SQL. I'm doing about 10 queries times 60.000 or so. It's quite slow. 8 hours in total (estimated time left). Now I would like to know where all of my execution time is going, so I was wondering if it's easy to do some profiling on esp. the SQL queries as I think there is where my time is going. Is there some sort of sql_query_time() routine. Or something similar? I'm quite new to SQL and even PHP so I'm don't know where to look either. -- Later Arnout http://www.supras.nl "Life is too short to drive an opel" -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
