Hi,

I have a huge and complicated problem. I'm new to FMPro8, I'm working for a new company that created there DB in 1994 by the boss who is not a computer professionnal. They've been adding fields and tables since then... not normalized!! :s So think about that 12 years of development without normalization.

My task is to create a new DB in parallele, but I also have to patch the original DB.

The problem is that I have a 1800+ fields in a single table. When refreshing data, the speed for refreshing textual data is Ok, but when there's some picture that they fetch on a NetDrive, it is way too slow (I'm talking about 5+ minutes to refresh a single layout).

I resized the cache to 100 MB, but it was even slower...

The image container is a multimedia field that is a result of a calculation. So every time that I change layout and come back to the problematic one, the DB is just refreshing all the data again!!

Can someone gives me a hint to accelerate the process?

Thank you

Descripe the nature of these images, in size and file-format!

--sd

Well, you have to remember, it's not refreshing all the fields within the record that are in that particular table, it's refreshing all the fields within the record that are on that layout -- Split this up to different layouts, or better yet, take a few days to export, re-structure and re-import