[PHP-DB] 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: [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 [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
Re: [PHP-DB] password in md5 to connect to mysql instead of clear password
Well, yes, but as my key is never transmitted from client to server, it's safer. ;) I encrypt a connect request with my private key, which is can be unencrypted by the public key, but the server knows it's me because only the private key can make the encryption. The message is sent over the network, but none of the tools to create it or read it are. -Micah On Friday 25 February 2005 08:59 pm, Jason Wong wrote: On Saturday 26 February 2005 04:16, Micah Stevens wrote: I was just thinking that a better way to do this is with a public/private key set. Then it would be secure, but as someone else mentioned, you'd have to patch the source to make it work. How would it be safer? Correct me if I'm wrong: if I have access to your key then I can connect. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- New Year Resolution: Ignore top posted posts -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Why isn't this working?
Hi everyone,
Im trying to split a string by comma, but its
not working, can you see any reason that the below doesnt work?
$keywords = preg_split(',','$Agent_Rep');
Thanks
Chris
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.5.0 - Release Date: 2/25/2005
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Why isn't this working?
Chris Payne wrote:
Hi everyone,
Im trying to split a string by comma, but its not working, can you see
any reason that the below doesnt work?
$keywords = preg_split(',','$Agent_Rep');
Not sure why you sent this to php-db, but have another look at the
preg_split documentation. You need '/,/' there to split on a comma.
-Rasmus
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] password in md5 to connect to mysql instead of clear password
On Sunday 27 February 2005 07:11, Micah Stevens wrote: Well, yes, but as my key is never transmitted from client to server, it's safer. ;) I encrypt a connect request with my private key, which is can be unencrypted by the public key, but the server knows it's me because only the private key can make the encryption. The message is sent over the network, but none of the tools to create it or read it are. The original question was concerning that if someone somehow had access to the file which stored the connections details then they would be able to use it to connect to the mysql server. Now if someone somehow had access to your key then it's game over for you. Unless you password protected your key which -- would be extremely impractical. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- New Year Resolution: Ignore top posted posts -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Why isn't this working?
For more efficient code try the explode() function (You really only want
to use the regular expression functions for complex pattern matching,
looking for a comma is about as simple as it gets so use the standard
string functions)
explode (',',$Agent_Rep);
graeme.
Rasmus Lerdorf wrote:
Chris Payne wrote:
Hi everyone,
Im trying to split a string by comma, but its not working, can you
see any reason that the below doesnt work?
$keywords = preg_split(',','$Agent_Rep');
Not sure why you sent this to php-db, but have another look at the
preg_split documentation. You need '/,/' there to split on a comma.
-Rasmus
--
Experience is a good teacher, but she sends in terrific bills.
Minna Antrim
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
