About the best you can do is make sure the image/blob format is compressed.
For two-color (i.e., black-and-white) invoices, the TIFF format is your best
bet.
Do you delete the images after printing? If not, you need to seriously
consider how to store them. Images generally take up a lot of space, and
Oracle isn't well known for handling high-volume blob transactions.
(Sorry--showing my Informix/document imaging/document management
background/bias here. No flames, please.)
-----Original Message-----
From: Stella Kravchenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 26, 1999 18:30
To: [EMAIL PROTECTED]
Cc:
Subject: PFCSIG Store images in the db table
Greetings,
Sorry for non-PFC question. We are using PB 6.5/pfc on Oracle 7.34. We
store
images (blobs) in the database table when users print invoices. This table
is
taking a lot of disk space on our production server. Could anybody make any
suggestions as far as reducing the amount of disk space used? I will be able
to
give more details if necessary.
Thanks in advance,
Stella Kravchenko
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
