Slow responce from Network

  • Thread starter Thread starter Derek Brown
  • Start date Start date
D

Derek Brown

Hi all
Been doin Databases for 10 years. Can't understand why this one is so slow
accessing only data from the network. the network is a bit of a selotape and
plaster job but I am only reading very small amounts of data. I have never
had this problem before, so can anyone offer ideas. Other programs seem to
load ok. Problem is much worse when two pcs access data at the same time.

Thanks
 
Derek,

There are all sorts of possible reasons -- you haven't told us much about
the application. For example, are you using Access as your back end DB or
are you going after SQL Server or Oracle or something else?

In general, with Access, keep in mind that it is NOT a client-server
oriented database, it is a file server database. If the program sits on
your local workstation but the data sits on the network server, then it has
to move indexes and big chunks of the database itself from the server to the
workstation in order to locate the data you want. If it's a big database
(i.e., large numbers of records), even if you're only reading very small
amounts of data at a time, it may be moving large volumes of data from the
server to the workstation.

Another possibility is that something in the application is locking one or
more tables so that you have to wait for something release the table lock
before you can grab your data.
 
Back
Top