Newbies balajipasumarthy Posted March 23, 2002 Newbies Share Posted March 23, 2002 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 Link to comment Share on other sites More sharing options...
Anatoli Posted March 23, 2002 Share Posted March 23, 2002 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8234 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now