I am using PostGreSQL 6.5.3 which I am really enjoying. It is very stable, pretty fast, has tons of features and above all, open source (7.0 which is to come out in a month has a slew more). Most of the data for the site is coming from the database (ZODB = 1.1 MB) and by playing with Zope's SQL Method caching I am really able to customize each and every SQL statement as to how much to cache and for how long. This really improves performance as cached material is said to be about 10x faster (not my tests). I have done some testing and on my server (RH 6.1, 300Mhz, 256 RAM) I think I can handle roughly 1,000,000 a day so should be ok for a bit. :) I have read everything I can get my hands on about ZEO but am still unclear about a few details like setup, management and the nuts and bolts of having one ZODB over many servers. All in good time. J
From: "Jason Spisak" <444@hiretechs.com>
There are also huge issues in terms of keeping multiple SQL databases synced up so there is a case to be made to spread ZEO across many webservers with one beefy DB server in the background serving them. That, combined with Zope's ability to cache creates a highly scalable solution (IMHO).
I, personally, am just salivating at the chance to get my hands on ZEO.
I too am waiting with my dinner napkin, knife and fork. Right now I have a 300MB ZODB and not having to deal with the overhead of a RDBMS (and the headaches everyone is having on the list) is very conforting. What DB are you using?