Re: IMAGE/PHOTO Performance:Oracle/Informix/Sybase/SQLSvr/DB2

We use Mezzanine with Sybase as the backend database engine which stores the images as blobs. Very good performance. Lee Gowen Michael Peppler wrote: > Evteev Michael wrote: > > > > Ok! > > MS SQL and Sybase have good perfomance on blobs... > > But many trouble on backup/restore database with blobs. > > By default blob operation is _not logged_. There are fast because don't save > > blos in log. > > And have size limit - 2M. Oracle - 4M > > Err - that's a 2 GB limit (or 2^31 - 1 bytes). > > Michael > > > PP wrote in message <36CC3B51.4821@hp.com>... > > >Dear Database Gurus: > > > > > >I am evaluating how best to store images and photographs in an > > >RDBMS, possibly as a BLOB or as a FILE. What in your experience > > >is the database of choice given either DB2, INFORMIX, SYBASE, > > >ORACLE and SQLSERVER ? > > > > > >In performance terms, does anyone have any independent reports > > >to quote from with regards to database performance for images > > >and photos storage/retrieval. Can you cite what the best performing > > >databases for image storage/retrieval ? > > > > > >Your comments are fully appreciated. Please email me if possible. > > >Thanks, > > > > > >PP > > -- > Michael Peppler -||- Data Migrations Inc. > mpeppler@mbay.net -||- http://www.mbay.net/~mpeppler > Int. Sybase User Group -||- http://www.isug.com > Sybase on Linux mailing list: ase-linux-list@isug.com