Re: [Phplib-users] Caching MySQL queries

[nathan r. h. <na...@ds...>]

On Tue, 30 Oct 2001, Donncha O Caoimh wrote:

> I'll send the patches on.
> I did a lot more work at the weekend on it. But here are some results:
> Without the cache reading 5,000 records takes 0.5 seconds every time.
> With the cache reading the same number of records takes 4.5 seconds to
> build the cache on the first run, and then 1.5 seconds each run after
> that for the life of the cache.

Nice...

> Doing an eval() is expensive and with the larger dataset just chews
> time.

Hurm.. i would think it wouldn't be...  Must be some remnant of perl still
lurking in the back of my head.. I will drink it into oblvion the next
chance I get :)

> I started work on another project (a weblog, coming along nicely!) and

Umm.. there are enough php weblogs.  Help an exsisting project :)

-n
-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
nathan hruby / digital statement
na...@ds...
http://www.dstatement.com/

Public GPG key can be found at:
http://www.dstatement.com/nathan-gpg-key.txt
ED54 9A5E 132D BD01 9103  EEF3 E1B9 4738 EC90 801B
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-