Re: Slow responce from Network
From: JP (jnospamperelst_at_optnospamonline.net)
Date: 02/23/05
- Next message: filo666: "Exists a function such as excel's =concatenate() in acces???"
- Previous message: Dave Elliott: "Re: Code on Current Event of Sub-Form"
- In reply to: Derek Brown: "Slow responce from Network"
- Next in thread: Immanuel Sibero: "Re: Slow responce from Network"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Feb 2005 17:27:58 -0500
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.
"Derek Brown" <derek@rapidspec.co.uk> wrote in message
news:%23PV1NWfGFHA.584@TK2MSFTNGP14.phx.gbl...
> 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
>
>
- Next message: filo666: "Exists a function such as excel's =concatenate() in acces???"
- Previous message: Dave Elliott: "Re: Code on Current Event of Sub-Form"
- In reply to: Derek Brown: "Slow responce from Network"
- Next in thread: Immanuel Sibero: "Re: Slow responce from Network"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
