Re: Upsizing to SQL Server - 09-30-2004 , 03:28 AM
On Wed, 29 Sep 2004 19:15:49 -0700, Tom van Stiphout
<no.spam.tom7744 (AT) cox (DOT) net> wrote:
are already more than powerful enough. The sort of processing I like
to see on the clients (referring to data-related examples) are things
like sorting, filtering and spreadsheet-like stuff which most systems
do by resending the dataset from the server in a different format.
The true server zealot (I'm sure you are not one!) is a megalamaniac
who wants to control every keystoke and doesn't think the user should
hava a computer at all. He is prepared for whatever network traffic is
necessary to achieve this, which is increasingly possible. Maybe that
is what I was reacting against.
Re: Upsizing to SQL Server - 09-30-2004 , 06:40 PM
Tom van Stiphout wrote:
simple SQL Trace will show you that this is incorrect. This is what
would happen with an mdb on the server. With an ODBC linked table to a
Server Engine the SQL statement WILL be passed to the server for
processing and only the results sent back. Even the use of DLookup
against a linked table sends a perfectly formatted SQL statement to the
server and only the matching rows returned.
modern PCs has more than enough processing power to do any processing
beyond the selection of the data.
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Re: Upsizing to SQL Server - 09-30-2004 , 08:33 PM
Tom van Stiphout <no.spam.tom7744 (AT) cox (DOT) net> wrote in
news:72ell0pd3ehb62tk1ktb0ahviau23lj8v2 (AT) 4ax (DOT) com:
server, so you do get the benefit of server-side processing for the
kinds of queries that *can* be handed off to the server.
If you're selecting and/or sorting on an Access/Jet expression,
you'll lose that benefit (though not entirely all of it in all
cases, since joins and other criteria on indexed fields could
significantly reduce the umber of records that will need to be
retrieved to calculate the expression values).
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc