you can measure the time by recording the time microtime at the beginning of the process and then again at the end and taking the difference...

For long processes that are dependant, I would use the INNODb table type and transactions to keep things in blocks for an all or none situation. Time limits for php can be set with the set_time_limit function.

For more high performance db stuff, have a look at Lots of great info there.


From: Chenri <[EMAIL PROTECTED]>
Reply-To: Chenri <[EMAIL PROTECTED]>
Subject: [PHP-DB] Large Process & How to measure time per process
Date: Sat, 26 Feb 2005 22:50:29 +0700

hello all,
i'm using the mysql and apache for a
matching price and bid transaction
and planned to process high volume

i've already set the mysql for max_connection
and the apache for max connection so it could
receive a lot of connections

but there one problem i've been thinking about
the capacity of PHP to process long queries,
i've noticed the timeout limit in PHP, and i have these questions:

1. if PHP script processing the queries exceed the timeout value how
will it stop? (show error message, roll back process or ....) And
should setting the timeout time larger will solve the problem?

2. How do i measure how long does the script process time? (any
software or scripts?)

3. How do i measure the memory used by this process?
Chenri J
Taman Palem Lestari B18 - 19A
(021) 926 68651 - Esia jadi bisa SMS

PHP Database Mailing List (
To unsubscribe, visit:

-- PHP Database Mailing List ( To unsubscribe, visit:

Reply via email to