Which way is better?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chemicals - 30 Oct 2007 22:19 GMT

I am trying to determine the most efficient method for querying data on a
backend SQL Server. Most of the queries require a parameter (or two) to be
passed and are all called from the VB code within a Form.

Is it:

A.) OpenRecordset "SELECT * FROM TABLE WHERE CONTRACT='AAA';

B.) Use a QueryDef with parameters

C.) Use an Access Query and pass parameters

Thanks

Reply to this Message

Jeff Boyce - 31 Oct 2007 00:59 GMT

There are so many other potential factors (size of table, indexing, network
connections, network traffic load, ...)...

What happens when you try the different approaches?

Regards

Jeff Boyce
Microsoft Office/Access MVP

> I am trying to determine the most efficient method for querying data on a
> backend SQL Server. Most of the queries require a parameter (or two) to
[quoted text clipped - 10 lines]
>
> Thanks

Reply to this Message