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
www.highperformancemysql.com. Lots of great info there.
Bastien
From: Chenri <[EMAIL PROTECTED]>
Reply-To: Chenri <[EMAIL PROTECTED]>
To: php-db@lists.php.net
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
transaction
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 (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
