Hi. Can anyone give some technical insight into the comparison of running queries from a back-end mdb (in a file-server situation) with the same queries on the frontend (using linked tables).
The reason I ask is that running queries on the BE is not an approach I have seen used, but initial testing has shown a 10% quicker execution with the queries on the BE db.
- Both FE and BE are Access 2000 mdb's.
- Both are currently local.
- Im using ADO connections in both situations to run the queries.
- Queries are all identical.
Any insight into what happens in a file-server, multiuser situation with queries on the backend rather than the frontend would be much appreciated.
Thanks for your time.
-will
The reason I ask is that running queries on the BE is not an approach I have seen used, but initial testing has shown a 10% quicker execution with the queries on the BE db.
- Both FE and BE are Access 2000 mdb's.
- Both are currently local.
- Im using ADO connections in both situations to run the queries.
- Queries are all identical.
Any insight into what happens in a file-server, multiuser situation with queries on the backend rather than the frontend would be much appreciated.
Thanks for your time.
-will
