I've a form that performs a data entry function to a parent and child table.
The datasources are all tied to local views.
The form as a pageframe with 2 pages and a grid with about 20 columns on it.
Over a 100mbps network, the form takes about 10-20 seconds to instantiate. From the coverage profiler, I've discovered that it is in the data environment open tables method (where I open all my tables) that is taking the bout of the time. (almost .5 seconds per table with about 16 tables opened). The largest table contain about 30k records.
I've already created indexes on all the key fields (I'm using surrogate keys to join the parent and child).
Is there a way to speed things up?
Thanks in advance
Yau