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