Speed of SQL queries, profiling?
| From: | Arnout van der Kamp | Date: | Thu, 15 Nov 2001 00:21:31 +0000 |
| Subject: | Speed of SQL queries, profiling? | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-10413@lists.php.net to get a copy of this message | ||
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"