Subject | Re: Database for images |
---|---|
Author | Glebas |
Post date | 2007-05-07T06:01:10Z |
Aage,
I have main database with complicated structure but moderate in size
and document database which is bigger 4-8 GB (but not 350 :) but
has one table and two fields: PK and a blob.
No probem so far, recently moved from 1.53 to 2.01.
You shall pay attention to the fact that table size limit of 35 GB
was removed in fb2 as you may read in release notes.
Regards,
Glebas
> I'm contemplating putting all of our images (3+ million, I think)10GB a year.
> into a single database. The table will just hold a PK, some
> identifying items (<16 bytes), and a blob to hold the images. A
> rough estimate gives a size of 350GB, with perhaps an additional
> A reason for moving from files to a database is to improve accesscontrol.
> The images are "compressed TIFF" - I'll try to do some additionalthey are.
> compression, but without significant benefit I will keep them as
> The size of the images varies: 50-500KB.I use the same approach for storing zipped office documents.
I have main database with complicated structure but moderate in size
and document database which is bigger 4-8 GB (but not 350 :) but
has one table and two fields: PK and a blob.
No probem so far, recently moved from 1.53 to 2.01.
You shall pay attention to the fact that table size limit of 35 GB
was removed in fb2 as you may read in release notes.
Regards,
Glebas