On Tue, Feb 25, 2003 at 04:36:23PM -0600, databarn wrote: > Folk, > > Two or three years ago, I was using ASP to access SQL Server 7 and MS > Access databases. There was a stopwatch dll made by CapRock Software > that allowed me to time various elements of my ASP scripts, > particularly the database queries. I found several SQL problems that > way, and made my queries much faster as a result. > > Is there anything similar to that stopwatch dll that I could run in my > PHP scripts to check the time on my MySQL queries? I'm seeing some > slowdowns, but can't quite nail them down, and would like to determine > if it is PHP or MySQL that I need to address.
Hello, Check out EXPLAIN and the slow query log in the manual. Cheers! -- Zak Greant <[EMAIL PROTECTED]> MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com MySQL Tip: Display the option files read by the server % mysqld --help --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
