I am using FM6

We display proofs as RGB jpeg files in a container filed.

The first 3100 proofs displayed great. Now, when a new proof is inserted the database locks up. It has to be forced to close (End Task) and last time had to be recovered.

Any thoughts

Well you might be nearing the file size limit in FM6. Anything near 2GB can cause profound flakiness.

The file is about 725 MB.

Is there another method of showing the proofs?

That size shouldn't be a problem, though you may be having a disc space issue. As a test I'd try deleting 1/2 the records, saving a compressed copy and then seeing if you can successfully insert a new proof. If you can it may be time to partition the proofs into more than 1 table or to store them by reference only instead of "in" container fields.

BTW, when you have to recover a file you should read this.

how do i store by reference

thanks,

jim shelton wrote:how do i store by reference

At the bottom of the Insert... dialog there is a check box to "Store only a reference to the file." Play around with this a bit. Its pretty cool.