This is a great tip. Thanks! I've added it to my folder of "tips to
speed up PHP".
Matthew Runo
http://www.quabbo.com
Quabbo Internet Services
The only host with the Zend Performance Suite!
On Aug 10, 2004, at 3:07 PM, Curt Zirzow wrote:
* Thus wrote Ed Lazor:
Any recommendations on how to make PHP run faster?
To help figure out which queries are running slow there is the
php.ini setting:
mysql.trace_mode=On
Using this will have the php library analyze your queries and if
any of them do table scans php will issue a warning about it, which
can be very helpful finding out where you need indexes.
I have a script pulling a lot of data from MySQL and generating
reports and
spitting out data (flush) as it's processing so I can see what's
going on.
It was taking around 10 seconds to process each order. I reduced the
total
number of orders being processed. I expected the script to take less
time
because there were fewer orders to process, but I was surprised to
discover
that time spent processing each order also reduced almost in half. I
figured PHP's memory limit per script at 8mb might be the bottleneck,
so I
upped it to 128, restarted apache, and reran the script. Increasing
available memory had no effect.
Its hard to say blindly where the bottle-neck is though.
Curt
--
First, let me assure you that this is not one of those shady pyramid
schemes
you've been hearing about. No, sir. Our model is the trapezoid!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
