[Zope] large images to a database via zope.
Dennis Nichols
nichols@tradingconnections.com
Thu, 12 Apr 2001 16:05:50 -0500
At 4/12/01 04:40 PM, ghaley@mail.venaca.com wrote:
>we are running zope 2.3.n with mysql 2.23.n (where n is i'm not sure the
>exact port). there is some sort of practical limit on the size of a file
>that mysql can insert (it's somewhere around 16MB), although a largeblob
>data type should be able to hold over a gig.
The advice usually is to *not* store images in the database, which then
voids the rest of your question. Store the images in the file system and
store only a link to them (and any meta-data) in the DB. Searching the
MySQL archives, you will certainly find repeated discussions of this.
--
Dennis Nichols
nichols@tradingconnections.com