Re: [Zope] alternative storage managers ?
Not sure if this helps but it sounds to me like you may want to look at storing the data in a rdbms. MySQL, ProgresSQL and Interbase are the free ones (not entily sure if this is true for interbase). I know oracle could do this (but of course it is expensive). Also the platform you are using is probably important for this type of stuff (i.e. go for unix).
Hi,
I would like to store several huge data-objects (10Mb and more) in the ZODB by use of ZOPE (Zope-2.3.0b1), but in my first tries I discovered, that the access to folders that include several huge objects becomes very slow.
I already tested the BerkeleyDB as an alternative --- it helped a little bit, but I had problems to get rid of unreferenzed objects by packing the BerkeleyDB; only the referenzes were deleted, but not the corresponding data in the BerkeleyDB.
Does anybody know, if there are other alternative storage managers available? In the "ZODB How-To" relational storage managers are mentioned,
but it's also mentioned that they are still experimental. For example is it possible to use the mySQL-DB and if so, where can I find
infos about that stuff?
Or is it necessary to store these objects externally as pickle-objects and
store only a referenz to them in the ZODB ?
best regards, Christoph
_______________________________________________ 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 )
Ben Edwards wrote:
Not sure if this helps but it sounds to me like you may want to look at storing the data in a rdbms. MySQL, ProgresSQL and Interbase are the free ones (not entily sure if this is true for interbase). I know oracle could do this (but of course it is expensive). Also the platform you are using is probably important for this type of stuff (i.e. go for unix).
Hi,
I would like to store several huge data-objects (10Mb and more) in the ZODB by use of ZOPE (Zope-2.3.0b1), but in my first tries I discovered, that the access to folders that include several huge objects becomes very slow.
Interbase is free and there is a storage product for ZODB under interbase at http://www.zope.org/Members/mcdonc/RS/InterbaseStorage but i have not tested it yet with zope 2.3 ciao azazel
On Wed, 7 Feb 2001, Ben Edwards wrote:
Not sure if this helps but it sounds to me like you may want to look at storing the data in a rdbms. MySQL, ProgresSQL and Interbase are the free ones (not entily sure if this is true for interbase). I know oracle could do this (but of course it is expensive). Also the platform you are using is probably important for this type of stuff (i.e. go for unix).
Hi,
I would like to store several huge data-objects (10Mb and more) in the ZODB by use of ZOPE (Zope-2.3.0b1), but in my first tries I discovered, that the access to folders that include several huge objects becomes very slow.
I sure would not want to store 10MB objects in MySQL. This sounds like a job for http://www.zope.org/Members/jfarr/Products/LocalFS -- Andy Dustman PGP: 0xC72F3F1D @ .net http://dustman.net/andy "Normally with carbonara you use eggs, but I used lobster brains instead." -- Masahiko Kobe (Iron Chef Italian): 30-year-old Giant Lobster Battle
participants (3)
-
Andy Dustman -
aZaZel -
Ben Edwards