I have a form with 7 (count 'em) sub forms, that takes a long time to load, ~30 seconds. 3 of the sub forms are based on sum queries. What are some general suggestions for speeding it up?
What do you think of the idea of creating tables for some of all of the sum queries? I know this is not "efficient" database design. However, the underlying data is updated only monthly, and it will (I assume) make the form load quicker.
Adam
__._,_.___
Posted by: runuphillracing@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar