when to opt for a backend DB over ZClasses?
I've done a number of smallish Zope sites that make heavy use of ZClasses and ZCatalogs. Now I'm involved with a project where we need to create (and search over) millions of objects. Even though the objects are relatively lightweight (just a few floats and strings), should we be using a backend database rather than ZClasses? This comes up a lot in the archives, but I've never seen a clear exposition of when one should forego the beauty of ZClasses for a more traditional (backend) storage. Cheers, Darran. --------------------------------------------- This message was sent using Endymion MailMan. http://www.endymion.com/products/mailman/
dedmundson@bigfoot.com writes:
I've done a number of smallish Zope sites that make heavy use of ZClasses and ZCatalogs. Now I'm involved with a project where we need to create (and search over) millions of objects. Even though the objects are relatively lightweight (just a few floats and strings), should we be using a backend database rather than ZClasses? This comes up a lot in the archives, but I've never seen a clear exposition of when one should forego the beauty of ZClasses for a more traditional (backend) storage. What about a little test with both approaches....
You should check: memory and time requirements for updates and searches is the ZODB growth acceptable Dieter
Why not do both? Use ZClasses, but keep the data in SQL with ZPatterns: http://www.zope.org/Members/sspickle/SQLZPatternsExample1 -steve On Sunday, September 2, 2001, at 05:02 PM, Dieter Maurer wrote:
dedmundson@bigfoot.com writes:
I've done a number of smallish Zope sites that make heavy use of ZClasses and ZCatalogs. Now I'm involved with a project where we need to create (and search over) millions of objects. Even though the objects are relatively lightweight (just a few floats and strings), should we be using a backend database rather than ZClasses? This comes up a lot in the archives, but I've never seen a clear exposition of when one should forego the beauty of ZClasses for a more traditional (backend) storage. What about a little test with both approaches....
You should check:
memory and time requirements for updates and searches
is the ZODB growth acceptable
Dieter
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Ok.. good point! You *can* use TransactionAgents, for Zope-2.4+. For Zope-2.3.x the standard ZPatterns release should work. -steve Chris Withers wrote:
Steve Spicklemire wrote:
Why not do both? Use ZClasses, but keep the data in SQL with ZPatterns:
Maybe 'cos there are no stable, binary ZPatterns releases, especially for Windows? ;-)
Chris
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Dangit.. forgot the URL: http://www.eby-sarna.com/pipermail/zpatterns/2001-August/000155.html -steve Steve Spicklemire wrote:
Ok.. good point!
You *can* use TransactionAgents, for Zope-2.4+. For Zope-2.3.x the standard ZPatterns release should work.
-steve
Chris Withers wrote:
Steve Spicklemire wrote:
Why not do both? Use ZClasses, but keep the data in SQL with ZPatterns:
Maybe 'cos there are no stable, binary ZPatterns releases, especially for Windows? ;-)
Chris
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (4)
-
Chris Withers -
dedmundsonï¼ bigfoot.com -
Dieter Maurer -
Steve Spicklemire