| | |
|
|
|
Accessing Access from the network |
|---|
| message from =?Utf-8?B?SmltIEQ=?= on 6 May 2004 |
We have Access 2000 running on a speedy XP Home "server" that is able to pull up a 400 MB database in about 2-3 seconds. When we access the database from workstations running 100Mpbs it takes about a minute to open up a query. This doesn't seem right to me. Anybody know why it takes so long to open it up from the workstations? I have 768 MB of RAM on my machine but it still takes way too long to access it. The server has 1 GB of RAM. Thanks for the help!
Jim
|
| Nikos Yannacopoulos replied to =?Utf-8?B?SmltIEQ=?= on 7 May 2004 |
Jim,
Apart from the processing power of the machine per se, which is very
important in running queries anyway, the decisive factor in this case is the
network. What I mean is, running a query on a workstation requires all the
records of all the tables involved to travel over the network to the
workstation to be processed, at a theoretical maximum of 100Mbps (network
traffic can actually limit throughput per workstation to only a fraction of
this), whereas doing the same on the server where the db is stored, the same
thing happens over an IDE/SATA (worst case, if not SCSI or RAID or
combination thereof) channel, which is a lot faster. Moreover, if the
workstation runs a FE accessing the main db on the server as a BE (which
should be the case for a multi-user PC), then the speed differences vs.
opening the BE db directly on the server can be dramatic, as a FE/BE scheme
is by definition slower than a monolithic database, much more so if you have
not taken specific steps to improve performance.
HTH,
Nikos
"Jim D" <anonymous@discussions.microsoft.com> wrote in message
news:E54AF31D-1616-4ABB-8F23-6DD3177C500B@microsoft.com...
pull up a 400 MB database in about 2-3 seconds. When we access the database
from workstations running 100Mpbs it takes about a minute to open up a
query. This doesn't seem right to me. Anybody know why it takes so long to
open it up from the workstations? I have 768 MB of RAM on my machine but it
still takes way too long to access it. The server has 1 GB of RAM. Thanks
for the help!
|
| Jim D. replied to Nikos Yannacopoulos on 7 May 2004 |
Thanks for the info.
Jim
|
|
Archived message: Accessing Access from the network (MS Access)
