We just converted an old system, as is, from FM5.5 to FM Pro 9. The smallest of all the files is the Timecard file. The Timecard table has 70 repeating fields, 14 of which are calculations. In addition it has 28 other calculation fields 14 of which are unstored. The only form takes a solid minute to load on a stand alone computer, and over a minute on the server. Paging through each time sheet takes about 5 seconds per timesheet (The form is in List View). I tried changing the form to Form View and while it pages faster, loading is still about the same. I think the issue is with the repeating fields, but cannot be sure as I have never worked with repeating fields.
It does have an open script which I removed to see it that would improve things, but it did not.
There are only 11 rows in the database. (It does not accumulate timesheets).
Can anyone tell me why the slow load, and if it is the repeating fields why they have that impact???
I can't think of anything else, but if you need more information, please ask!
Start Free Trial
