[AccessD] Search in AC2007 and SQL-Server

_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________



Yes, that was my understanding and experience.  Using Stored Procs on the server to do all the heavy lifting and using pass thru queries will get you the performance.
but I am no expert in SQL Server, still tinkering at the edges (or at least it feels like that).

cheers
Darryl.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Sunday, 14 November 2010 4:34 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Search in AC2007 and SQL-Server

Isn't the larger issue whether or not a stored procedure is called vs.
dynamic SQL ?
Also, what about ODBC vs. a native driver ?
I thought both of these were hugely important, no ?


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> David McAfee
> Sent: Friday, November 12, 2010 2:03 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Search in AC2007 and SQL-Server
>
> SQL Server will definitely be faster, but it really depends
> on what you are returning.
>
> How many fields are coming back? What type of fields are
> they? Are the WHERE clause fields indexed?


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________________________________________________

The information transmitted in this message and its attachments (if any) is intended 
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review, 
retransmission, dissemination or other use of, or taking of any action in reliance 
upon this information, by persons or entities other than the intended recipient is 
prohibited.

If you have received this in error, please contact the sender and delete this e-mail 
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute 
the information contained in this e-mail and any attached files, with the permission 
of the sender.

This message has been scanned for viruses.
_______________________________________________________________________________________