On Tue, Mar 12, 2002 at 11:37:20AM -0800, Henry Hank wrote: > > Hello All, > > I've recently installed mySQL on a RH7.2 box without any problems > - it runs great. I've been testing some long running queries (full > table scans, etc) under different scenarios, and get wildy differing > results. Between each test case, I was flushing all tables and > re-starting the mysql deamon. When I run one of my longest queries > in the mysql command line client, it runs in about 77 seconds. When > I run the identical query via PHP running on the box, the same query > takes about 930 seconds to complete. For the life of me, I can no > figure out why the identical query would run differently from the > command line than from PHP. I've repeated this test about 10 times > just to be sure - and it is entirely repeatable: command line - > about a minute - PHP - about 16 times longer. Any ideas or > suggestions?
Watch top on the machine and see if Apache/PHP is getting significant amounts of CPU time during the test--of if it's just MySQL. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 33 days, processed 1,065,257,232 queries (370/sec. avg) --------------------------------------------------------------------- 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