Hi: I too was curious about this subject, and found a couple of links that can shed some light hopefully (I think one for them from Matthew): http://aspn.activestate.com/ASPN/Mail/Message/zope-Dev/1006799 http://www.zope.org/Products/OracleStorage/OracleStorageFAQ.html The real question is...anyone out there with a real world app can share some real performance data...? Is it worth the while going to an OracleStorage solution...or not? Regards, Jorge M. Matthew T. Kromer wrote:
Alvaro Carneiro wrote:
Hello All,
It´s possible Zope use to store the site in a MySQL, Oracle, etc ?
Zope store all site in a few files in /var directory, what the limit of this internal database ? It´s reliable ?
Any document about this ?
tks again
**
Hello Alvaro,
It is possible to replace the FileStorage (the default Data.fs file) with a different storage, such as an OracleStorage.
I recommend there be strong business reasons for using an RDBMS over FileStorage -- the RDBMS interface will typically be several times (between 5x and 50x depending on how well tuned the RDBMS is) slower than FileStorage.
Also, objects that are stored in OracleStorage are still opaque -- you cannot query them from outside Zope and get meaningful results back.
The Zope FileStorage can use more than 2G of disk space so long as your version of Python and your operating system support large files. It is a very reliable storage; part of this is due to the simplicity of the model it uses.
I dont know offhand of any document that discusses the merits of FileStorage vs OracleStorage (or any other alternative Zope storage) but you may be able to find one with Google.
-- Jorge O. Martinez MIS Senior Associate eMediaMillWorks 1100 Mercantile Lane, Suite 119 Largo, MD 20774 E-mail => jmartinez@eMediaMillWorks.com Phone => (301)883-2482 ext. 105 Fax => (301)883-9754