Takes time to show results

[balajipasumarthy]

Hi,

I am using filemaker 4.1 for an MIS system that I have developed for use in my business. There are customer data files, billing file, receipt files, transaction file etc. which are linked to one another. For certain reports where calculations are involved and data has to be captured from related files, it takes a long time for the complete report to appear on the screen. Sometimes there are a lot of blank spaces and when I take my cursor to that field and click only then the value appears. Out of the 6 files which are linked only one has around 3000 records the other has 2000 the rest have very few records. Most of the calculations are adding up data from the related file etc.

Know I need to know the following:

1) Is there a limit in terms of data, records, files shared etc. beyond which filemaker has a problem processing data.

2) Or does it have to do the definition of the field in terms of storing / not storing the calculation results.

3) Is there a processor issue. I am using a P3 processor.

I had no problem getting the same reports under test conditions with lesser number of record.

Looking forward for your help.

Regards

Bala

[Anatoli]

1. No.

2. Stored will be faster.

3. More FM version issue. Version 5 is not using the old search and indexing engine developed by another company and it is faster by 200-700%.

4. It also depends on your design.

5. It depends on speed of your hard disks.

6. All operations are heavily disk based. In theory you'll get dramatic speed advantage with fast SCSI subsystem.