Slow import

[Heckate]

Hi, i'm migrating a 52 database FM6 system to FM 7. All files converted without any major problems but i had to do some cleanup, which took about a week, so then i cleard all the records and did another conversion and imported the newly converted file's records into the older but cleaned up shells. 51 of the databases imported OK but one of them, which only had about 2000 records in it is taking hours. Other files imported much faster and had more records. Does anyone know of a reason for this. There's nothing in this database that isn't in others as far as i know.

Any help would be appreciated.

Heckate

[Søren Dyhr]

Read what Jack Rodgers writes in www.macintouch.com/fmp7part02.html

FileMaker introduces slowness to imports when it must calculate values in related fields, summaries of related fields and a large number of calculated fields. Where other DBS import text files seemingly instantaneously, FileMaker must devote time to process EACH record for calculated fields. Thus if you do a sum of a related field, it must find, load and sum each of those records. The more related records the longer it takes. For this reason, if you are doing a lot of importing and deletion, avoiding calculated fields is recommended. I try to script such calculations whenever a user opens a record since that only costs a fraction of a second and avoids the long delays in updates caused by calculated fields in such circumstances.

--sd

[Heckate]

Thanks Soren. At least now i know why it's so slow. I'll be more careful about what fields i import in the future.

Thanks again for your help and fast response.

[Fenton]

Also be sure you've upgraded to the latest version, 7.0v3. There were memory problems with earlier versions, when you did repeated Imports. I thought it was only if you ran the same import over and over, but I don't really remember. But udgrade in any case.