Subject | Database for images |
---|---|
Author | Aage Johansen |
Post date | 2007-05-06T20:04:17Z |
I'm contemplating putting all of our images (3+ million, I think)
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 10GB a year.
A reason for moving from files to a database is to improve access control.
The images are "compressed TIFF" - I'll try to do some additional
compression, but without significant benefit I will keep them as they are.
The size of the images varies: 50-500KB.
Any warnings?
Should I choose a pagesize of 16KB (rather than 8KB or 4KB)? Will it matter?
Currently using Fb/1.5.4
Backup/restore will be fun, of course. But since the images never
change I might put all old images into one database (which will be
totally static), and new images into another one (which will need the
occasional backup). This is really an unneeded complication. Maybe
a better alternative would be to keep the images (coming from a
scanning process), and - if necessary - reload from these.
Advice appreciated.
TiA
Aage J.
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 10GB a year.
A reason for moving from files to a database is to improve access control.
The images are "compressed TIFF" - I'll try to do some additional
compression, but without significant benefit I will keep them as they are.
The size of the images varies: 50-500KB.
Any warnings?
Should I choose a pagesize of 16KB (rather than 8KB or 4KB)? Will it matter?
Currently using Fb/1.5.4
Backup/restore will be fun, of course. But since the images never
change I might put all old images into one database (which will be
totally static), and new images into another one (which will need the
occasional backup). This is really an unneeded complication. Maybe
a better alternative would be to keep the images (coming from a
scanning process), and - if necessary - reload from these.
Advice appreciated.
TiA
Aage J.