I've put up a proposal I'd like to put into 2.6.1 or 2.7, whichever is next. Summary: "Change ZSQLMethods to allow a user to a) change the database connection without changing the object and b) use standard cache managers." http://dev.zope.org/Wikis/DevSite/Proposals/ZsqlMethodImprovements Any comments or ideas welcome. Cheers. -- Andy McKay www.agmweb.ca
Hmm... (a) Is a great idea (b) How would this work in practice? Adrian... -- Adrian Hungate EMail: adrian@haqa.co.uk Web: http://www.haqa.co.uk ----- Original Message ----- From: "Andy McKay" <andy@agmweb.ca> To: <zope-dev@zope.org> Sent: Thursday, October 17, 2002 11:07 PM Subject: [Zope-dev] Proposal: Improving ZSQL Methods
I've put up a proposal I'd like to put into 2.6.1 or 2.7, whichever is next.
Summary: "Change ZSQLMethods to allow a user to a) change the database connection without changing the object and b) use standard cache managers."
http://dev.zope.org/Wikis/DevSite/Proposals/ZsqlMethodImprovements
Any comments or ideas welcome.
Cheers. -- Andy McKay www.agmweb.ca
_______________________________________________ Zope-Dev maillist - Zope-Dev@zope.org http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
(b) How would this work in practice?
Make a RAM Cache Manager, and then assign the ZSQL Method to cache in that cache manager, just like you would any other object. The results are then cached according to the database connection and the query in the RAM Cache Manager. It means we have a much more flexible and powerful caching mechanism available that is not thread specific. -- Andy McKay www.agmweb.ca
Hi. At Thu, 17 Oct 2002 16:00:22 -0700, Andy McKay wrote:
(b) How would this work in practice?
Make a RAM Cache Manager, and then assign the ZSQL Method to cache in that cache manager, just like you would any other object. The results are then cached according to the database connection and the query in the RAM Cache Manager.
as you know, sqlmethod has own cache function in advanced tab. and I think RAMCache can not cache object like Shared.DC.Results. Regards -- Yusei TAHARA
as you know, sqlmethod has own cache function in advanced tab.
Exactly, I am removing that functionality.
and I think RAMCache can not cache object like Shared.DC.Results.
At the moment Im caching the raw sql results before it gets parsed into a Result object, as noted towards the end of the proposal. -- Andy McKay www.agmweb.ca
On Monday 21 October 2002 04:08 am, Yusei Tahara wrote:
Hi.
At Thu, 17 Oct 2002 16:00:22 -0700,
Andy McKay wrote:
(b) How would this work in practice?
Make a RAM Cache Manager, and then assign the ZSQL Method to cache in that cache manager, just like you would any other object. The results are then cached according to the database connection and the query in the RAM Cache Manager.
as you know, sqlmethod has own cache function in advanced tab. and I think RAMCache can not cache object like Shared.DC.Results.
i don't see why not. just make sure their unwrapped before you store them. -k
participants (4)
-
Adrian Hungate -
Andy McKay -
kapil thangavelu -
Yusei Tahara