container field locking up database

General support questions.
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Mon Jan 23, 2006 2:29 pm
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
JIMBO
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Mon Jan 23, 2006 3:04 pm
Well you might be nearing the file size limit in FM6. Anything near 2GB can cause profound flakiness.
John Sindelar
SeedCode
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Tue Jan 24, 2006 5:35 am
The file is about 725 MB.

Is there another method of showing the proofs?
JIMBO
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Wed Jan 25, 2006 6:45 am
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.
John Sindelar
SeedCode
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Wed Jan 25, 2006 8:42 am
how do i store by reference

thanks,
JIMBO
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Wed Jan 25, 2006 9:24 am
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.
John Sindelar
SeedCode

Return to General Support

Who is online

Users browsing this forum: No registered users and 3 guests

cron
(855) SEEDCODE
[email protected]
Follow us: