Speed of form load
Posted: Wed Nov 28, 2012 11:01 pm
Hi,
We have a dashbboard view of a student record which has 8 tabs, and many tabs have subforms, sometimes 2 or 3.
It works, but the more subforms I use the slower it gets to load.
On my system it seems to work at around half a second per subform, and the form can take 3-4 seconds to load after selecting from browse.
For most of my users there are less subforms on their own departmental forms - but this one form is a "master" view of everything, so needs all the subforms.
Is there anything I can do to speed this up significantly.
If not I can live with as the benefits are great.
I do have indexes on the keys but not done too much tuning up on the sql yet.
Martin
We have a dashbboard view of a student record which has 8 tabs, and many tabs have subforms, sometimes 2 or 3.
It works, but the more subforms I use the slower it gets to load.
On my system it seems to work at around half a second per subform, and the form can take 3-4 seconds to load after selecting from browse.
For most of my users there are less subforms on their own departmental forms - but this one form is a "master" view of everything, so needs all the subforms.
Is there anything I can do to speed this up significantly.
If not I can live with as the benefits are great.
I do have indexes on the keys but not done too much tuning up on the sql yet.
Martin