A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Slow responce from Network



 
 
Thread Tools Display Modes
  #1  
Old February 23rd, 2005, 11:21 PM
Derek Brown
external usenet poster
 
Posts: n/a
Default 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  
Old February 23rd, 2005, 11:27 PM
JP
external usenet poster
 
Posts: n/a
Default

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  
Old February 23rd, 2005, 11:40 PM
Immanuel Sibero
external usenet poster
 
Posts: n/a
Default


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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 10:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.