My gamble is that it would certainly speed it up.
The only warning I would have is that if you have linked tables for multiple front end access, and run delete and append queries to refresh the data, you'll see more bloat.
But since as you say this is done monthly, you could manage that well enough.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, October 01, 2015 10:31 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Speeding up form with multiple subforms
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
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar