Client side cache for prepared queries
[email protected] (Julien Palard) Tue, 2 Aug 2011 11:02:55 +0200
| Newsgroups | php.pdo |
|---|---|
| Message-ID | <CAOO=pgC4SN0qSXhqBar2sJNGJp_C7zTco2bP_+GqHbFD2um26g@mail.gmail.com> |
Hi there, Can't find any documentation about an eventual client side cache for prepared queries, that should be a performance gain when used with persistent connections : * First page open first connection to DB, prepares a request R1, cache it locally, executes it. * Second page reuse first connection, reuse prepared request, just executes it. The client side caching of these queries seems simple to implement with an hashtable of queries (as we have not to replace values I'm not speaking about a result cache, but a prepared query cache.) Also I never heard of caching of prepared statement server side, so it should be a great improvement to cache them client side unless I missed something ? -- Julien Palard