RE: [PHP-DB] Large Process & How to measure time per process

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 <chenrijano@gmail.com> Reply-To: Chenri <chenrijano@gmail.com> 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