Performance Speed

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I am having some database performance issues which I am sure is somewhat
related to my network. I was hoping that you could suggest some ideas to help
increase its performance. The design is a front end back end application.
When I run all objects locally the application screams but when I move the
tables up to the wide area network it slows way down (to the point where no
one will want to use it. Any suggestions would be helpful. Thanks
 
Jason said:
I am having some database performance issues which I am sure is somewhat
related to my network. I was hoping that you could suggest some ideas to help
increase its performance. The design is a front end back end application.
When I run all objects locally the application screams but when I move the
tables up to the wide area network it slows way down (to the point where no
one will want to use it.
Click to expand...

The three most common performance problems in Access 2000 or newer
are:
- LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off

If the problem is for everyone when starting up the MDB then it likely
needs a decompile.

For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
If you really mean WAN rather than LAN, your best solution is to have the
remote users use your application via terminal services or Citrix. Few WANs
these days run over leased lines and so they simply do not have the
bandwidth to support a client/server application. Think about it this way -
Speed of the typical LAN
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
Speed of the typical WAN
;;;;

Terminal services and Citrix will provide "local" speed since the
application actually runs on the network server. No data/forms/reports, etc
are pushed over the network. All the remote user sees is the screen shot of
what is happening with his session on the server.
 
Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top