Large Process & How to measure time per process

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

RE: 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
>Reply-To: Chenri
>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