[Zope] Search on ZCatalog or ZSQL in MySQL

Steve Drees drees@the-bridge.net
Thu, 24 Aug 2000 12:11:00 -0500


> the true decision however the current database news is about 350M and i
> would like to extend it to store images and file, so is possible that at
> the final year if everyting comes ok it outperforms the 1GB data

The limit I think you refer to is the 2GB file size limit on _some_
OSes. So you really have more room than you thought you did, and you may
have more room than you can imagine depending on your platform.

Some things I would suggest.

Store the stories in the ZODB.
Store URLs for the images in the ZODB as properties of the story.
Store the images on the filesystem and serve them out of apache or some
other static webserver.

That'll help keep your Data.fs size down and also give you a little better 
performance.