Have you considered looking at memory caching mechanisms (using APC Cache for example) to reduce queries to database? Quite simple really by overriding the doSelect, doSelectOne, retrieveByPk and other database retrieval methods. In other words, when a query is sent to the database, check if the result is stored in APC Cache. If it is yank and return, if not, query database and store in memory cache. If a field is being altered (save() or delete() methods), remove the record from APC so that the next query gets the updated result. We use this quite extensively on one of our projects and has dropped a lot of db load off our server.
On Tue, Nov 23, 2010 at 1:22 AM, Ken Golovin <[email protected]> wrote: > I would like to be able to cache a partial on a search results page > that uses query strings, however symfony ignores caching settings. The > page on http://www.symfony-project.org/reference/1_4/en/09-Cache > says: > > "An incoming request with GET parameters in the query string or > submitted with the POST, PUT, or DELETE method will never be cached by > symfony, regardless of the configuration." > > Is there any way to override this behaviour? > > -- > If you want to report a vulnerability issue on symfony, please send it to > security at symfony-project.com > > You received this message because you are subscribed to the Google > Groups "symfony users" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<symfony-users%[email protected]> > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en > -- Gareth McCumskey http://garethmccumskey.blogspot.com twitter: @garethmcc -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
