Where is Oracle ZODB storage ? Large file support in NT 4 ?
I would like to move my ZODB to a DBMS (probably Oracle) Goals: - Get around the 2 gigs limit in NT4. - Speed up data access. Questions: - Where can I find Oracle ZODB Storage ? - Where could I find compiled Python with enabled larges files support ? - How can I speed up data access in a large ZODB ? Can ZEO speed things up if only used on one multiple processors server ? Ho, one final thing... ZOPE really rock !!!! :)) Jeff
Jean-François Ménard wrote:
I would like to move my ZODB to a DBMS (probably Oracle)
Goals:
- Get around the 2 gigs limit in NT4. - Speed up data access.
Questions:
- Where can I find Oracle ZODB Storage ? - Where could I find compiled Python with enabled larges files support ? - How can I speed up data access in a large ZODB ? Can ZEO speed things up if only used on one multiple processors server ?
Ho, one final thing...
ZOPE really rock !!!! :))
Jeff
Oracle Storage is in DCOracle2 -- just download the latest tarballs from http://cvs.zope.org/Products/DCOracle2 to get it. There are some (slightly dated) instructions in the DCOracleStorage directory. A lot of people want an NT build of Python which includes large file support. At this time, Zope Corporation doesn't actually build Python on NT to bundle with Zope; we just take the standard Python release build. Now, thats not to say that PythonLabs couldn't ever build a NT version with large file support enabled, but there isn't an official NT binary release right now with large file support. -- Matt Kromer Zope Corporation http://www.zope.com/
Jean-François Ménard wrote:
I would like to move my ZODB to a DBMS (probably Oracle)
Goals:
- Speed up data access.
I don't think this will be speed it up. I read some time ago that berkley storage is much slower than a the storgage in the filesystem of ZODB. If you store your data in ZODB and not in an SQL-Database and have performance problems you might try BTrees. BTrees are much faster if you store a lot of Objects in a Folder. thomas
On 20/03/02, 10:36:41, Thomas Guettler <zopestoller@thomas-guettler.de> wrote regarding Re: [Zope] Where is Oracle ZODB storage ? Large file support in NT 4 ?:
I don't think this will be speed it up. I read some time ago that berkley storage is much slower than a the storgage in the filesystem of ZODB.
There are reasons other than performance to want to store ZODB in an SQL RDBMS: you might want to access data stored in ZODB objects from programs which have no practical interface to Zope. Or you might simply want all your textual data in one place where you can categorise and organise them. The applications I intend to develop with Zope have to work in an environment where most programming is done in VB (ugh) and data stored in MSSQL Server. If I wanted to use a Zwiki, I would want the text stored in the MSQL datastore. What is the current status of ZODB-in-SQL? -- Bruce
On Wed, 20 Mar 2002 11:08:04 GMT, Bruce Richardson <itsbruce@uklinux.net> wrote:
you might want to access data stored in ZODB objects from programs which have no practical interface to Zope.
there's no such thing ;-)
Or you might simply want all your textual data in one place where you can categorise and organise them.
But BerkeleyStorage and DCOracle storage dont store textual data in the database. Like all ZODB storages they store *pickled* *objects* If you want to store text in your SQL database then you need a database adapter, not a storage.
The applications I intend to develop with Zope have to work in an environment where most programming is done in VB (ugh) and data stored in MSSQL Server. If I wanted to use a Zwiki, I would want the text stored in the MSQL datastore.
Can they make http requests to zope? xmlrpc or soap requests? Toby Dickenson tdickenson@geminidataloggers.com
Bruce Richardson wrote:
<snip>
What is the current status of ZODB-in-SQL?
What you're refering to is somethign totally different, often known as object-relational mapping. I have lots of energy but little resource for this. Maybe someone else has got further? Dunno wha tDBObjects does but it sounds promising... cheers, Chris
Bruce Richardson writes:
There are reasons other than performance to want to store ZODB in an SQL RDBMS: you might want to access data stored in ZODB objects from programs which have no practical interface to Zope. Or you might simply want all your textual data in one place where you can categorise and organise them. You may want to look at ZPattern...
However, storing meaningfull data in external storage will require some work from you. Dieter
On Tue, 19 Mar 2002 13:13:51 -0500, Jean-François Ménard <jeanfrancoismenard@msn.com> wrote:
- Speed up data access.
It is very rare that the 'storage' layer of Zope is a performance bottleneck. Changing one storage for another is unlikely to make much performance difference, either for good or bad. Can you tell us more about this slowness? Toby Dickenson tdickenson@geminidataloggers.com
Chris Withers wrote:
Jean-François Ménard wrote:
- Speed up data access.
Last I heard, OracleStorage we as several orders of magnitude slower than filestorage ;-)
cheers,
Chris
Actually, I've gotten DCOracleStorage running at only 1/5 the write speed of FileStorage; which is pretty good. -- Matt Kromer Zope Corporation http://www.zope.com/
participants (7)
-
Bruce Richardson -
Chris Withers -
Dieter Maurer -
Jean-François Ménard -
Matthew T. Kromer -
Thomas Guettler -
Toby Dickenson