Speed of form load

[martbarr]

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

[admin]

Martin,

One thing I can suggest, so that you know what is taking the longest time (building the page or loading it) is if you are logged in as globeadmin.

You should find something like this in the HTML source..

Code: Select all

</div>
</form>
</body>
</html>

<!--built in 0.1224958896637 seconds, 70 queries, thread id 184, local time Tue, 04 Dec 2012 15:29:39 +1030-->

Steven