note 70105 added to function.mysql-free-result

From: Date: Tue, 03 Oct 2006 16:23:24 +0000
Subject: note 70105 added to function.mysql-free-result
Groups: php.notes 
Request: Send a blank email to php-notes+get-117983@lists.php.net to get a copy of this message
this function is awesome. as far as i can tell, the "Open Tables" field from the mysql_stat() function updates faster than without it. i was having problems with too many connections to a database, so i duplicated that db across different servers. i then made a php page that, judging by the "Open Tables" field, decides which server to connect to using a tiered system. sometimes the "Open Tables" would get super high, and i'd have to get it to delay connecting to any db at all to give the servers some time to recupe, and once the dbs' "Open Tables" dropped below my set max, it would carry on with the connection delegations. ever since i added mysql_free_result() in, it has been noticeably faster at recovering from high "Open Tables". im sure i'll be putting this function alongside my mysql_close()'s, cuz why the heck not? ---- Server IP: 66.207.199.35 Probable Submitter: 24.79.77.79 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-free-result.php Edit -- https://master.php.net/note/edit/70105 Del: integrated -- https://master.php.net/note/delete/70105/integrated Del: useless -- https://master.php.net/note/delete/70105/useless Del: bad code -- https://master.php.net/note/delete/70105/bad+code Del: spam -- https://master.php.net/note/delete/70105/spam Del: non-english -- https://master.php.net/note/delete/70105/non-english Del: in docs -- https://master.php.net/note/delete/70105/in+docs Del: other reasons-- https://master.php.net/note/delete/70105 Reject -- https://master.php.net/note/reject/70105 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#117983) next »