I have a multi user database that has the tables on a shared network drive and the forms and queries Installed on the local workstations(Split). The database consists of 2 tables that get added to frequently and several lookup tables that feed data to combo boxes on the main form. The lookup tables get infrequent updates but each table gets read often. I have a link to each of these tables, which I assume means a lot of network traffic with the reads going on. My question is would I reduce traffic if the lookup tables were local and update them occasionally or since it seems to be performing OK just leave well enough alone?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Linked or update local
- Thread starter NewHere
- Start date
The simple answer is yes, it will reduce network traffic. By how much, and whether it will be noticeable depends on number of users and number of lookups.
It sounds like a very small database - only 2 tables! If these 2 tables have a large number of fields, then they should probably have been normalised, which would speed things up more noticeably than changing the location of lookup tables.
I think that the benefit will be outweighed by the hassle of updating a lookup table in every client (as the more clients that you have means more gains if the lookup table is local, it also follows that you will have to update the lookup on more client machines).
Why not just try doing it? It's simple enough, and just as simple to reverse.
Regards,
Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."
It sounds like a very small database - only 2 tables! If these 2 tables have a large number of fields, then they should probably have been normalised, which would speed things up more noticeably than changing the location of lookup tables.
I think that the benefit will be outweighed by the hassle of updating a lookup table in every client (as the more clients that you have means more gains if the lookup table is local, it also follows that you will have to update the lookup on more client machines).
Why not just try doing it? It's simple enough, and just as simple to reverse.
Regards,
Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."
- Status
Similar threads
- Locked
- Question
- Locked
- Question