Post reply

Access speed

  • June 24, 2005 at 2:24 am

    #68144

    Hi

    I have an Access 2000 (soon to migrate to 2003) with a lot of linked tables to SQL Server.

    As more people in the Organisation are beginning to use the database, the load times seem to be slowing.  I'm not sure if this is a database design problem, or just the network (which does appear to go through slow periods).

    What issues do I need to address to ensure that when, say 50 people are accessing the database concurrently, the access speeds remain acceptable?

    Paul

  • June 24, 2005 at 2:28 pm

    #568412

    Tough question.

    Make sure you understand how MS ACCESS works

    Minimize the records you pulldown to Access

    Separate the jobs that can be done better in the server from those that can be done better in vba or MSACCESS

    ACCESS is an excellent tool when used wisely

     


    * Noel

  • June 28, 2005 at 4:50 am

    #568870

    Thanks, Noel

    Sorry for the delay - I've only just had the chance to get back to this.

    When tables are linked, does this provide a load on the individual PC connection as it is, or is it only when data is requested?  I can't quite get my head around this.

    I generally find that on an individual PC that if I run an Access query on linked tables, it runs quicker that using a view or sp.  However, would it be better to use a view or sp thus (I guess - though I'm not sure), minimize network traffic and speed up data access to a larger number of users.

    Paul

  • June 28, 2005 at 1:03 pm

    #569105

    The Problem with a linked table is that the "Filtering" of the data (depending of course on what you are doing) happens on the FRONT END, with SPs is done at the back end level.

    BTW the MS ACCESS DEVELOPERS HANDBOOK that I recomend is not the one by Mary Chipman is SET of two books one for Desktop and another for Enterprise (which touches a lot of issues about Multiuser environments and MSACEES)  by Paul Litwin, Ken Getz, Mike Gunderloy :

    you can find those here and the developers web site here

    hth

     


    * Noel

  • June 29, 2005 at 2:31 am

    #569235

    Thanks Noel

    I'll check these out.  I need to get a good grip on this.

    Thanks again for your time and trouble.

    Paul

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply