slow browsing records

[Karel Roos]

I defined a container field (repeating, 6x)and put it on a layout. I use this field to LINK PDF files to project records. Those files are on a shared network drive. Most records contain 2 a 3 links in that field en browsing the project records became very slow. Those links are set to be updated automatically.

Has anyone some tips to optimize recordbrowsing in this context?

[Steverino]

I'm having the problem with extremely slow browsing of large PDFs in container fields.

Anybody have suggestions?

[Genx]

1) Don't store the files in the same FM file

2a) Either setup an additional FM file to store the PDF's and reference that

or...

2b) Setup some sort of script to store all PDF's on a network drive and only reference them in FM.

3) Run file maintenance on your files.

[Genx]

Oh, re-reading your post... Don't use repeating fields, use a related table, and a portal, showing only one container field... That way it will only load the first document unless you scroll downward.

[Steverino]

Thanks for all the suggestions. Rather than displaying the PDF icons, I ended up using a calculation to display only the PDF names (GetAsText). I then made that into a button, which script puts the PDF on the desktop and opens it.

Much improved -- very fast.