How much data that bound form fetch at a time ?


G

Guest

I have question in mind that if database contains more than 1 million
records, How much data (records or KB or number of pages) that bound form in
MDE and ADP fetch at a time ? I don't think MS Access XP will load all
records when bound form is opened. And Can I control MS Access the amount of
data to be read at a time ? It will be great if I can control this factor to
reduce the network traffic :)

Thanks in advance
 
Ad

Advertisements

M

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The best way to reduce traffic is to only retrieve one record at a time.
Create a Search form that allows the user to create the criteria that
will select whichever record they want. The search form creates a
statement (call to a Stored Procedure (SP) w/ parameters, or an SQL
string) that will be placed in the working form's RecordSource. This
will retrieve the desired record.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQVR2eoechKqOuFEgEQKnzACg5/0byVBvQvaGhU5r8n9wdiSGY4wAn1RP
FlGTS8wxeQkVSRYSIHnf/1tQ
=Bpmm
-----END PGP SIGNATURE-----
 
M

Malee

I have question in mind that if database contains more than 1 million
Uhmmm....Interesting Question . Have anyone know ? I also would like to
know.

Malee.
 
D

Daryl

Malee said:
form in



Uhmmm....Interesting Question . Have anyone know ? I also would like to
know.

Malee.
Malee
I suppose if you look at a form used in a adp app it has a default load
of something like 10,000 records. So my guess would be that your
recordset that is bound to the form will load up to that default, if you
want more than that you have to change the default value. I think there
is a Max Records setting as well. However, I agree that the best way is
to allow the user to restrict the number of records, if you want the
application to be scalable then this is a must.

Usually the control has the intelligence, some controls are 'virtual in
nature' i.e. they only retrieve records that are visible to the user
within the control. I don't think an adp form does this - only a guess
though.

I understand you are looking for a definitive answer, probably a
Microsoft software engineer could help on this one?

daryl
 
Ad

Advertisements

D

Daryl

Malee said:
form in



Uhmmm....Interesting Question . Have anyone know ? I also would like to
know.
Malee
I suppose if you look at a form used in a adp app it has a default load
of something like 10,000 records. So my guess would be that your
recordset that is bound to the form will load up to that default, if you
want more than that you have to change the default value. I think there
is a Max Records setting as well. However, I agree that the best way is
to allow the user to restrict the number of records, if you want the
application to be scalable then this is a must.

Usually the control has the intelligence, some controls are 'virtual in
nature' i.e. they only retrieve records that are visible to the user
within the control. I don't think an adp form does this - only a guess
though.

I understand you are looking for a definitive answer, probably a
Microsoft software engineer could help on this one?

daryl
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top