 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / March 2005Performance Issues
We have an Access 97 application that performs quite slow on the network. The app is split into a FE and BE and there is a persistent connection from the FE to the BE. I think this is mostly a result of our network. Our desktops are configured at 10 Mbps. I explained that increasing this setting to 100 Mbps would improve performance. Management doesn't agree this will help. I would think this should boost performance approx 10 times. Is this correct or have I missed something. Any comments or articles on this would be greatly aprreciated. Thanks. > We have an Access 97 application that performs quite slow on the > network. The app is split into a FE and BE and there is a persistent [quoted text clipped - 6 lines] > times. Is this correct or have I missed something. Any comments or > articles on this would be greatly aprreciated. Thanks. It would most definitely help if the reason for slowness is the time it takes to pull records over the network. It is also possible that design changes could provide as large or larger of a speed increase if proper indexing and other design considerations have not been implemented as well as they should be.  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com Definitely worth a try. Make sure you're using switches not hubs. They probably no longer sell hubs these days. But if you're still on a 10Mbps network, you may be using hubs. Immanuel Sibero > We have an Access 97 application that performs quite slow on the network. > The app is split into a FE and BE and there is a persistent connection from [quoted text clipped - 6 lines] > missed something. Any comments or articles on this would be greatly > aprreciated. Thanks. No doubt the LAN speed upgrade will make a big difference, but if you haven't already done so, take a look at: http://www.granite.ab.ca/access/autofe.htm by Tony Toews. The tips and tricks there can deliver a much more spectacular improvement. HTH, Nikos > We have an Access 97 application that performs quite slow on the network. > The app is split into a FE and BE and there is a persistent connection from [quoted text clipped - 6 lines] > missed something. Any comments or articles on this would be greatly > aprreciated. Thanks. >No doubt the LAN speed upgrade will make a big difference, but if you >haven't already done so, take a look at: [quoted text clipped - 3 lines] >by Tony Toews. The tips and tricks there can deliver a much more >spectacular improvement. Thanks but I suspect you meant http://www.granite.ab.ca/access/performancefaq.htm Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Absolutely! >>No doubt the LAN speed upgrade will make a big difference, but if you >>haven't already done so, take a look at: [quoted text clipped - 14 lines] > Microsoft Access Links, Hints, Tips & Accounting Systems at > http://www.granite.ab.ca/accsmstr.htm >We have an Access 97 application that performs quite slow on the network. >The app is split into a FE and BE and there is a persistent connection from >the FE to the BE. Good. >I think this is mostly a result of our network. Our desktops are configured >at 10 Mbps. I explained that increasing this setting to 100 Mbps would >improve performance. Management doesn't agree this will help. I would think >this should boost performance approx 10 times. Is this correct or have I >missed something. Any comments or articles on this would be greatly >aprreciated. There is definitely a major difference in performance between 10 mpbs and 100 mpbs. It won't be 10 times but definitely much, much better. On a previous laptop the network card auto sense didn't work properly at one particular clients. It was quite slow. Once I notice only the 10 mpbs light being on I forced the connection speed to 100 mpbs and performance was much, much better. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.