On Wed, Jan 29, 2003 at 03:32:20PM +0900, Wankyu Choi wrote:
I've been thinking:
1. Take out as much binary data as possible via External File ( my version, not the ones found in Zope products page ).
i can understand doing this if you're running FileStorage and want to avoid a single bloated Data.fs file, but since you're leaning towards DirectoryStorage, I think there's no reason to use ExternalFile at all - it just complicates things.
Hm.. your reply pretty much convinces me^^ Now I'll be trying DirectoryStorage in earnest.
2. Store textual data ( raw data + its rendered version, etc ) in MySQL.
ditto
Why shouldn't I let DirectoryStorage also take care of this? Toby Dickenson seems to prefer putting everything into the storage. ( I need to keep searchable textual data in MySQL tables anyway since Zope's catalog engine is a pie in the sky for me: Korean simply doesn't work since there's no reliable Korean splitter; will have to rely on old '%word%' select tricks. :(
3. User data goes into MySQL.
ditto
Again why? In fact, I want to keep the existing user data where they are but am just curious what I would be missing if I didn't^^
once but that seemed a lot of hassle, so I decided to wait for other solutions like the Directory Storage.
Wait no longer. ;)
Okay, but is there anything I should be aware of before deciding on the directory storage as my storage of choice? The data will be both read- and write-intensive.
If most Zope users ( including yourself ) feel Filestorage is not a solution for more than 20GB of data,
hell, I don't like it for 2 GB of data. (see recent thread "POSKeyError II: Dead by Dawn" ... I wasn't kidding when I titled it that!)
Yeah, that POSKeyError thing scares the hell out of me ;-)
Anonther solution that hasn't been mentioned in this thread: multiple mounted storages. Never done this, but I understand zope.org does it (one storage for wikis, another for everything else). http://www.zope.org/Members/jim/ZODB/MountedDatabases
Can I mix it with the DirectoryStorage?
Shane's DBTab allows you to mix-and-match storages, running several at once. http://www.my-zope.org/exp/20030116101458 http://hathaway.freezope.org/Software/DBTab
I tried Shane's AdaptableStorage with DBTab. Works with stock Zope and CMF. Doesn't work with Plone. Will have to wait for it to stabilize a bit more. Thanks for your comments. Cheers, Wankyu Choi --------------------------------------------------------------- To the dedicated staff at NeoQuest, language is not a problem to be dealt with, but an art waiting to be performed. --------------------------------------------------------------- Wankyou Choi CEO/President NeoQuest Communications, Inc. 3rd Floor, HMC Bldg., 730-14, Yoksam-dong, Kangnam-gu Seoul, Korea Tel: 82-2 - 501 - 7124 Fax: 82-2-501-7058 Corporate Home: http://www.neoqst.com Personal Home: http://www.zoper.net, http://www.neoboard.net e-mail: wankyu@neoqst.com ---------------------------------------------------------------