Quick Question

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hi,

I am wondering what is faster. I am useing OLEDB to connect to an Access
database and was wondering which is faster. Calling a query saved in Access
or using SQL in the program? And is it a big difference in performance.

Thanks in Advance
 
Why you execute a stored query it is slightly faster as the compile step is
not required. It's also somewhat safer as SQL injection attacks and
Parameter typing prevent other problems. Since the queries are pretty simple
in Access, this compile step won't save you a lot of execution time but it
will make your application more stable.

hth

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Keep in mind though if you are using the database for a web app and there
will be multiple users, Access will lose its advantages quickly with each
open connection.

Stephen
 
Back
Top