question about resource consumption in the Jet database

[Paul]

Two questions about resource consumption in the Jet database:

1. I understand that when you have a split database, the back end will have
to do more work to deliver 10,000 records to a form or query than to deliver
10 records to the same form or query. But *after* the data has been
delivered by the back end to the front end, does the back end have to keep
working harder if the open query (in the front end) has more records, or
does it not make any difference after the data has been transferred to the
front end?

2. A related question: if you keep 3 hidden (and bound) forms open in the
front end of a split database, does this cause the back end to work any
harder (*after* all the data has been delivered to the three forms) than if
the front end only has one form open?

Thanks in advance,

Paul

 

[Rick Brandt]

Two questions about resource consumption in the Jet database:

1. I understand that when you have a split database, the back end will
have to do more work to deliver 10,000 records to a form or query than
to deliver 10 records to the same form or query. But *after* the data
has been delivered by the back end to the front end, does the back end
have to keep working harder if the open query (in the front end) has
more records, or does it not make any difference after the data has been
transferred to the front end?

A query does not "work harder" based on the number of records returned.
If a larger record-set is returned you might get all of the rows returned
at once or you might get a few data-pages with more data being pulled as
required. This depends on how the data is being utilized in the front
end.

2. A related question: if you keep 3 hidden (and bound) forms open in
the front end of a split database, does this cause the back end to work
any harder (*after* all the data has been delivered to the three forms)
than if the front end only has one form open?

The back end (if an mdb file) does zero processing work. ALL that is
done on the computer running the front end. The back end only does
processing work when it is a server back end like SQL Server.

In a standard split-mdb setup the back end computer does have to do work
to pull the required data off of its hard drive. That work stops when
all of the data has been delivered regardless of how many forms, reports,
or queries in the front end are pulling that data.

 

[Paul]

Great!

Thanks for the explanations, Rick.

Paul