MS Access Query vs. SQL 7 Stored Procedure

[Scott Elgram]

Hello,
I herd somewhere that queries written in access that query a SQL
database are run either partially or completely with the clients memory.
I have 6 update queries that are in access that update tables in SQL.
Each of these queries takes about 2 or so minuets. In an effort to speed
things up a bit I thought to move them to stored procedures. Is this really
going to make a bit a difference?

 

[Dirk Goldgar]

Hello,
I herd somewhere that queries written in access that query a SQL
database are run either partially or completely with the clients
memory. I have 6 update queries that are in access that update
tables in SQL.
Each of these queries takes about 2 or so minuets. In an effort to
speed things up a bit I thought to move them to stored procedures.
Is this really going to make a bit a difference?

Maybe yes, maybe no; it depends on the details of the query. But you
could try changing them to pass-through queries, rather than creating
stored procedures in the SQL Server database, and see the difference it
makes. If your queries don't take parameters, there's probably no
reason to make actual stored procedures.