Hank,
i donīt know, but i thing the PHP have a time out for the "PHP process" and 
a time out for the MySQL connection,
cause i a lot of people that donīt like to stay 70 seconds in front of 
computer :)
probably have some way to extend the time out

At 05:30 20/03/02 -0800, you wrote:

>Hello - I'm posted this to the mysql list but got no response.  While it 
>sounds
>like a mysql problem, I'm convinced that it is a PHP problem (see bottom of
>note.)
>
>   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 a simple PHP script running on the box, the
>same query takes about 930 seconds to complete.  For the life of me, I can 
>not
>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?
>
>  I'm running RH 7.2 (2.4.9-21) on a Dell Poweredge 2550, 1GB memory, 
> RAID, with
>mysql version 3.23.41 (the standard install unchanged from the RH 
>media).  Here
>is the query...pretty simple:
>
>             insert into summary_table
>                select frb, denom, series,
>                count(*) as cnt,
>                sum(bills) as bills,
>                sum(bills_hit) as bills_hit,
>                sum(total_hits) as total_hits
>                from detail_table
>
>If it a memory/cpu resource problem, how do I set RH to give PHP and 
>Apache the
>same priority as the mysql deamon?
>
>I've also written a small Perl script to execute the same queries, and that
>runs in 70 seconds (same as mysql client), so there must be some
>memory/processor limitation placed on PHP that prevents it from running as
>quickly as these other methods.  Any ideas/suggestions?
>
>Many thanks in advance..
>
>  -Hank
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! Sports - live college hoops coverage
>http://sports.yahoo.com/
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php

Henrique Flach Latorre Moreno
Smart Tech Consulting
www.smartech.com.br
Av. Rio Branco 181, 1005
Centro - Rio de Janeiro - RJ
Tels : (21) 2532-6335


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to