note 66489 added to function.mysqli-prepare

From: Date: Wed, 24 May 2006 09:00:58 +0000
Subject: note 66489 added to function.mysqli-prepare
Groups: php.notes 
Request: Send a blank email to php-notes+get-111915@lists.php.net to get a copy of this message
That's not exactly true. The prepared statement is stored in the database, and is therefor faster to execute next time. This means that the second time a page is rendered, it's not eating as much database CPU. Even in a different page, if it's the exact same query string. Ie, even the "prepare" call is faster the second time, since the database can see that it already did that prepare once. ---- Server IP: 147.32.160.17 Probable Submitter: 81.232.79.126 ---- X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER autolearn=no version=2.64 ---- Manual Page -- http://www.php.net/manual/en/function.mysqli-prepare.php Edit -- http://master.php.net/note/edit/66489 Del: integrated -- http://master.php.net/note/delete/66489/integrated Del: useless -- http://master.php.net/note/delete/66489/useless Del: bad code -- http://master.php.net/note/delete/66489/bad+code Del: spam -- http://master.php.net/note/delete/66489/spam Del: non-english -- http://master.php.net/note/delete/66489/non-english Del: in docs -- http://master.php.net/note/delete/66489/in+docs Del: other reasons-- http://master.php.net/note/delete/66489 Reject -- http://master.php.net/note/reject/66489 Search -- http://master.php.net/manage/user-notes.php

« previous php.notes (#111915) next »