"You may download this PECL extension DLL from the PHP Downloads page or at http://snaps.php.net/. Note: On Windows, APC expects c:\tmp to exist, and be writable by the web server." On 9/28/05, Thomas <tomatosh@xxxxxxxxx> wrote: > Thanks, that looks good. But what do I do if OS is WinDoze? The install of > the pecl only gives a .so *feeling sorry not everything runs on xp* ... > > I will take the time to benchmark the serializing vs db calls ... is there a > good benchmark tool out there (without having to use microtime inside the > scripts)? > > Thanks > > T > > -----Original Message----- > From: Jasper Bryant-Greene [mailto:jasper@xxxxxxxxxxxxxxxxxx] > Sent: 28 September 2005 11:41 AM > To: php-general@xxxxxxxxxxxxx > Subject: Re: serializing result sets or what? > > Thomas wrote: > > Q: What would be the best way to save db calls for large result sets? > > > > I thought about serializing the data and then caching it (with Cache_Lite > - > > maybe there will be a future inclusion of such a caching scheme into the > php > > core or pecl?). I was not sure about performance though (no time for > > benchmarking this). > > > > The issue is that as this system grows we get 2 - 3 db calls on the server > > (which is too much in my opinion), but will serializing be cheaper or > simply > > the lesser of two evils? > > A very similar question was asked recently on this list. You might like > to consider caching whatever you create from those result sets rather > than the result sets themselves, but APC [1] is worth looking at as I > believe it can cache (some?) PHP vars without serialisation, using > apc_store() and apc_fetch(). > > The only way to know whether such a scheme would help in your specific > situation is to benchmark. Go on, it won't take long! > > [1] http://php.net/apc > -- > Jasper Bryant-Greene > Freelance web developer > http://jasper.bryant-greene.name/ > > -- > 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 > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
