hello i have mysql ver 3.22.29 installed. My problem is that i m using mysql_ping at a lot of places (i.e before every query) to check whether i have connection or not , in a program which is running in deamon every 10 seconds i.e i dont close the connection anywhere, just connect once and keep calling mysql_ping whenever i have to fire a query. Now the problem is my program keeps increasing the cpu usage with time,i dont know if the mysql_ping handles the allocation & deallocation of database handle on its own, or we need to first close connection explicitly and then connect again. I have searched the archives & could not find any specific answer. Now the Question IS: What is the trade off between using a query to find out whether we have lost connection & then doing a close connection & then connecting again AND using mysql_ping after every query? Please help............ Thank u rachna [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
