NearImpossible
Registered User.
- Local time
- Yesterday, 18:40
- Joined
- Jul 12, 2019
- Messages
- 225
I have a split SQL/Access database and an entry from with around 100 fields on it that gets split into 8 other tables.
I currently have it setup as a 1 pass through query with multiple INSERT and UPDATE clauses, which works just fine. I'm just wondering if it would operate any faster, or slower, if i had it as a local query in Access and use multiple APPEND and UPDATE queries to accomplish it.
Not really sure on the differences in performance pushing the query across the network to work on the SQL server or having it local and moving data between linked tables.
Of course I can build the queries and test it for results, but can someone explain best usages of Pass Through vs Local queries?
thanks
Kevin
I currently have it setup as a 1 pass through query with multiple INSERT and UPDATE clauses, which works just fine. I'm just wondering if it would operate any faster, or slower, if i had it as a local query in Access and use multiple APPEND and UPDATE queries to accomplish it.
Not really sure on the differences in performance pushing the query across the network to work on the SQL server or having it local and moving data between linked tables.
Of course I can build the queries and test it for results, but can someone explain best usages of Pass Through vs Local queries?
thanks
Kevin