<< What is the compression/overhead when storing pictures as blobs? The database is currently app. 60 Mb and it would grow considerably if the photos are stored in the database. What would be the performance penalty? >>
400 K times 1,000 photos = 400 megabytes. 5 times that is 2 gigabytes. Blobs are stored in the RB4 file. Since it cannot grow to over 2 gigabytes, at the outside limits of your requirements you would be pushing the file size limit. There is no further compression of blobs in the database and JPGs are already compressed so even if you manually compressed and uncompressed them you wouldn't see any gain. Aside from that, since the images are stored in the 4 file and only a reference to the image in the 2 file, and you have a compartively small number of images (and this a small number of rows in your images table), you probably would not see a performance penalty doing non-image-related stuff in the database. -- Larry ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
