|
|
Posted by Ol!v!ι on 10/22/40 11:33
david epsom dot com dot au wrote:
>>UPDATE table SET column = 'value'
>>table contained approx. 7000 records. The packet count for
>>this with SQL Server was exactly 9. When using MS Access as
>
>
> None of my clients would let you near their SQL Servers!
>
> If you have your 25 (min) SQL Server users doing updates
> like that, all the real users will be out to lunch while
> they wait for their applications to respond!
>
> Building applications for 25 users means not writing
> queries like that.
The query I wrote was only for the demonstration of the difference in
network load between MS Access and SQL Server, not as an example on how
to write queries.
OliviΓ©
Navigation:
[Reply to this message]
|