| re: Access and SQL Server - Query based on Query issue
Trever & Flavio,
Further, the more you can get SQL Server to do in TransactSQL and just
deliver a finished result to Access, the better.
"Trevor Best" <nospam@besty.org.uk> wrote in message
news:423206c0$0$8747$db0fefd9@news.zen.co.uk...[color=blue]
> Flavio wrote:[color=green]
>> Hi,
>>
>> I'm used in MS Access on Doing Queries based on Queries.
>>
>> Now that I'm dealling a lot with large ammount of data I think this
>> procedure with an SQL Server back-end is falling a little bit in
>> performance...
>>
>> Some of the Queries are VERY complicated and I had to break it in
>> something like 5 or 6 queries...
>>
>> DOES IT AFFECT PERFORMANCE? And how can I get rid of this problem??
>>
>> Give me tips so I can study on it...[/color]
>
> Are you using Access queries based on linked tables?
>
> If so, anything more complex than say 2 tables and one join will result in
> Access starting to issue sp_prepare and sp_execute statements at the
> server, 1 for each row in the query, this is very very inefficient.
>
> The best thing to do is create views on the server, these can be linked
> just like tables.
>
> --
> This sig left intentionally blank[/color]
| 
