Relationship and speed issue

[Kieron]

I have a database and there are 3 tables that are contained within. These are kept separate due to the need of being able to lock different parts of the information at different times.

The problem I am having is that if I have a layout that contains information from 3 different tables there seems to be a delay in moving between the fields (up to 2 seconds). These are all linked by a single common identifier

The tables do contain a large amount of data (over 70,000 records per table, but I am looking to increase this up to 300,000) and they are served by a G5 across the network at 100Mbps

This will start to become very cumbersome when entered data.

Is there something I am missing as I wouldn't except such a long delay between fields?

Thanks,

Kieron

[Ender]

I haven't seen or heard about this type of delay problem in FM7, so I'm guessing it's something with your setup or your structure.

Are your running Server 7 to host this database? If running Server, how much RAM is installed in the machine and what is the cache level set to in Server Administration?

Can you describe the structure of your database? How are the tables related? Which table is the problem layout based on? It is mostly text information or are there graphics stored in container fields for those records? Are there any summary fields or calcs with aggregate functions (Count(), Sum(), etc.) on the layout you're having trouble with?

Can you tell if it's slow when EXITING a particular table's records or when ENTERING a particular table's records?

[NYPoke]

Still learning V7, but in general, you can add one thing to add to Ender's list:

Are all your Related Fields Indexed?