perfromance question

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

The networking activities on the task manager whows 50% or more when I
copy a big file from a file server to my local drive, but it shows
only up 2 % when MS Access to query data from the server.

I just wonder are there any limitation of networking for MS Access?
If networking activities is like copy file 50 % or more then my MS
Access report will 25 times faster.

Can we programming to improve networking performance using VBA or am I
missing anything here?


Your information is great appreciated,
 
I have not idea what you are trying to do, but there is nothing you can do
programmatically to improve system performance with VBA. All you can do is
be aware of what data you are retrieving and how you are doing it that
affects you application performance.
 
iccsi said:
The networking activities on the task manager whows 50% or more when I
copy a big file from a file server to my local drive, but it shows
only up 2 % when MS Access to query data from the server.

I just wonder are there any limitation of networking for MS Access?
If networking activities is like copy file 50 % or more then my MS
Access report will 25 times faster.
Click to expand...

The difference though is that any reads of a record are actually reads
to a number of data pages. That is the first read of the BE MDB is
to determine the start page of the table you want to read. Then the
next set of reads would be the indexes that match your selection
criteria. Finally a read is performed of the actual 4kb page that
contains the record of interest. If it's a query then needless to say
the reads get a lot more complex in a hurry.

Now a file copy just reads a whole bunch of data and the server and
the client can fill up all kinds of buffers and optimize the reads and
writes of the hard drives at both ends as well as the data streaming
down the wire.

So it's not possible to match that performance given the nature of the
back and forth reads of an Access MDB.

This is also the reason why SQL Server and similar are a lot more
network efficient and sometimes significantly faster, although not
always, than Access. The SQL box does all this back and forth
between the CPU and the hard drive and then makes the final result of
the data available to the client app such as Access.

Tony
 
Back
Top