By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,375 Members | 1,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,375 IT Pros & Developers. It's quick & easy.

Data Across The Network

P: n/a
Given a backend on a network server and a frontend on a local computer, when is
data pulled across the network? For example, does Rst.Recordcount pull data
across the network? How about Rst.Findfirst? When a form or report opens, do
they pull all the data in the recordsource across the network?

Thank you for your help!

Corrine
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
"Corrine" <cm****@earthlink.net> wrote:
Given a backend on a network server and a frontend on a local computer, when is
data pulled across the network? For example, does Rst.Recordcount pull data
across the network?
Yes,it probably has to pull the entire recordset down as there is no way of telling
the server to do any processing.
How about Rst.Findfirst?
A little bit of data yes.
When a form or report opens, do
they pull all the data in the recordsource across the network?


Yes, I would think they would pull all the data in the recordsource down. Reports
may even do it twice if you have "Page x of y" in the footer which is the standard
default report format.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #2

P: n/a
Thanks for responding, Tony!

So what are some things to do when writing an application to minimize network
traffic?

Corrine
"Tony Toews" <tt****@telusplanet.net> wrote in message
news:f4********************************@4ax.com...
"Corrine" <cm****@earthlink.net> wrote:
Given a backend on a network server and a frontend on a local computer, when isdata pulled across the network? For example, does Rst.Recordcount pull data
across the network?
Yes,it probably has to pull the entire recordset down as there is no way of

telling the server to do any processing.
How about Rst.Findfirst?
A little bit of data yes.
When a form or report opens, do
they pull all the data in the recordsource across the network?


Yes, I would think they would pull all the data in the recordsource down.

Reports may even do it twice if you have "Page x of y" in the footer which is the standard default report format.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Nov 13 '05 #3

P: n/a
Tony Toews <tt****@telusplanet.net> wrote in
news:f4********************************@4ax.com:
"Corrine" <cm****@earthlink.net> wrote:
Given a backend on a network server and a frontend on a local
computer, when is data pulled across the network? For example,
does Rst.Recordcount pull data across the network?


Yes,it probably has to pull the entire recordset down as there is
no way of telling the server to do any processing.


Hmm. I don't think so. It's only going to pull the entire recordset
if you've done .MoveLast.

Of course, maybe that is a Rushmore issue -- that the recordset is
being retrieved asynchronously and if you waited long enough, you'd
get an accurate .Recordcount even without a .MoveLast.

It would also depend on whether or not the recordset has an ORDER BY
clause. But even then, if the fields are indexed, it might need to
retrieve only the indexes, order them appropriately, and then
retrieve the actual data pages only when they are called for.
How about Rst.Findfirst?


A little bit of data yes.


Again, given indexes, it should be fairly minimal.
When a form or report opens, do
they pull all the data in the recordsource across the network?


Yes, I would think they would pull all the data in the
recordsource down. Reports may even do it twice if you have "Page
x of y" in the footer which is the standard default report format.


Just to clarify: this question sounds like a variation on the
accusation frequently levelled by people who simply don't understand
Jet that it pulls the entire table across the network any time you
request data. Jet does no such thing. I pulls the minimum amount of
data it needs to walk through the index trees and data pages to find
the specific data requested.

I would expect recordsets to have the same efficiencies, though
probably, in the end, all the data for the rows requested is, in
fact, retrieved across the network.

But not any more than that!

So, keep your recordsets as small as possible to get the job done --
don't retrieve it all and jump around it with .FindFirst. Instead,
use an appropriate WHERE clause to retrieve only the data you want.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #4

P: n/a
"David W. Fenton" <dX********@bway.net.invalid> wrote:
But even then, if the fields are indexed, it might need to
retrieve only the indexes, order them appropriately, and then
retrieve the actual data pages only when they are called for.


Good point. That makes sense.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #5

P: n/a
"Corrine" <cm****@earthlink.net> wrote:
Thanks for responding, Tony!

So what are some things to do when writing an application to minimize network
traffic?


The obvious one is to minimize the number of records retrieved. If a complex form
with a number of subforms on different tabs only fill the subforms when a given tab
is selected. Same for combo boxes on different tabs.

Why are you asking though? Are you having performance problems? Going to be using
Access over a WAN?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.