If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Slow responce from Network
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 |
#2
|
|||
|
|||
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" wrote in message ... 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 |
#3
|
|||
|
|||
Derek, If you havent already, take a look at: http://www.granite.ab.ca/access/performancefaq.htm in particular, the info about locking file and opening a persistent connection HTH, Immanuel Sibero "Derek Brown" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
File | Open slow when connected to network | J Meyer | General Discussions | 0 | February 10th, 2005 04:23 AM |
Open/save files very slow over network with word 2003 | Darren | General Discussion | 2 | January 12th, 2005 06:27 PM |
Slow to link tables over a network | Scott M | General Discussion | 2 | July 9th, 2004 02:07 AM |