Re: [PHP-WIN] Speed of SQL queries, profiling?

2001-11-15 Thread Arnout van der Kamp
> By the way, your question is rather not that much about php. (Not that I > uses php and care that much... :) Well I was more thinking of some profiling routines than checking the actual SQL queries. I've done so with 'explain' command and it seems the queries all make use of the right index fil

[PHP-WIN] Speed of SQL queries, profiling?

2001-11-14 Thread Arnout van der Kamp
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 quer