I found this on Zend - SQL Query Caching -
http://www.zend.com/zend/tut/tutorial-staub2.php;
The basics to caching is using the serialize() and unserialize() PHP
functions...
I don't know if this will help.
Nick
-Original Message-
From: Peter Janett [mailto:[EMAIL PROTECTED]]
Sent: 23 January 2003 08:41
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Re: query caching caching in general
Query caching is something that seems to exist in Cold Fusion, but not PHP.
What I'm referring to is that in Cold Fusion you can specify that query
results be cached in memory, and how long to cache those results. So, if
you have a page that runs the same query each time it's loaded, and you
cache a query on that page, then the results of that query are in memory, so
the call to the database is not run, instead the results from memory are
used, which can represent a HUGE speed increase.
To be totally repetitive, I'm not talking about a database cacheing results
of a query, but PHP caching the results of the query, instead of querying
the database.
I don't think it's possible to do anything like this in PHP, because of the
multiple database support, different function calls for different databases,
etc.
I've looked around, and found some PHP code that saves results sets in tmp
files, but I'm guessing that having the results cached in memory would be
faster than in files.
I think maybe the file caching was part of a database abstraction layer.
HTH,
Peter Janett
New Media One Web Services
New Upgrades Are Now Live!!!
Windows 2000 accounts - Cold Fusion 5.0 and Imail 7.1
Sun Solaris (UNIX) accounts - PHP 4.1.2, mod_perl/1.25,
Stronghold/3.0 (Apache/1.3.22), MySQL 3.23.43
PostgreSQL coming soon!
http://www.newmediaone.net
[EMAIL PROTECTED]
(303)828-9882
- Original Message -
From: Jean-Christian Imbeault [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 1:20 AM
Subject: [PHP] Re: query caching caching in general
Justin French wrote:
anyone got any links to decent tutorials on sql caching, and caching in
general?
A few questions:
At what level do you want the caching?
Are you talking about stored procedures?
Do you mean storing functions in the DB? (some DB's, like PostgreSQL can
compile functions once and reuse the compiled function).
Let me know where you want the caching to be and maybe I have a link or
two.
Jc
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
This private and confidential e-mail has been sent to you by Egg.
The Egg group of companies includes Egg Banking plc
(registered no. 2999842), Egg Financial Products Ltd (registered
no. 3319027) and Egg Investments Ltd (registered no. 3403963) which
carries out investment business on behalf of Egg and is regulated
by the Financial Services Authority.
Registered in England and Wales. Registered offices: 1 Waterhouse Square,
138-142 Holborn, London EC1N 2NA.
If you are not the intended recipient of this e-mail and have
received it in error, please notify the sender by replying with
'received in error' as the subject and then delete it from your
mailbox.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
