Results 1 to 11 of 11
  1. #1
    Join Date
    Oct 2007
    Posts
    214

    Question Unanswered: Speeding up database

    How can i speed up my access database so it performs searches faster and works more efficiently? I use the compact and repair function frequently, but i'm not sure if that's the only way. It does not seem to speed anything up. Thanks
    Last edited by benz1984; 11-10-08 at 14:34.

  2. #2
    Join Date
    Feb 2004
    Posts
    214

    Couple of Questions?

    Access Version:
    Operating System:
    System Specs (Ram, CPU):
    Database Size:
    # of Records:
    You know, I'm sick of following my dreams, man. I'm just going to ask where they're going and hook up with 'em later

  3. #3
    Join Date
    Oct 2007
    Posts
    214
    it is access 2003 part of office professional

    i'm at about 1.7 ghz pentium 4

    about 600 mb ram

    i have about 65k records or more in the database

    Thanks!

  4. #4
    Join Date
    Feb 2004
    Posts
    214

    ...

    65k records is not a whole lot and normally wouldn't be a problem. The 600mb or ram however will affect your database no matter how many times you compact and repair.

    when you run your search, do you need to search through all 65k records, or can you query some out? Reducing the number of records you are searching usually helps.
    You know, I'm sick of following my dreams, man. I'm just going to ask where they're going and hook up with 'em later

  5. #5
    Join Date
    Oct 2007
    Posts
    214
    I normally need to search through them all. It usually is quite slow. That's my biggest concern. How to speed these searches up.

  6. #6
    Join Date
    Feb 2004
    Posts
    214

    ...

    Sorry I couldn't help. The only thing I found effective was to reduce the number of records I was searching whenever possible (unfortunately in your case it is not). Upgrading to 1gb of ram, preferably 2gb will make a world of difference.

    Another question, is your table a link to another db or is it a local table?
    Also, is your db on a server or on your desktop. Sometime putting it on your desktop can speed it up if your network is slow.
    You know, I'm sick of following my dreams, man. I'm just going to ask where they're going and hook up with 'em later

  7. #7
    Join Date
    Oct 2007
    Posts
    214
    It's local and on the desktop. I just thought maybe there was a general way to help speed up the database ... i know they can hold a lot more records than 65 k ... but i can't imagine searching through any more since it's already taking quite some time (approximately 5 seconds) but that is pretty significant when you have a heavy workload. Thanks!

  8. #8
    Join Date
    Feb 2004
    Posts
    214

    ...

    I am not aware of any way to speed up the search through access directly. I use to have the same problem and until my company upgraded my ram did the problem ever go away.
    You know, I'm sick of following my dreams, man. I'm just going to ask where they're going and hook up with 'em later

  9. #9
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I can't really think of any circumstance when you'd want to return 65K records all at once! My brain can't process that much rubbish in a month.

    The WHERE clause is about to become your best friend.
    George
    Home | Blog

  10. #10
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    ▲ Is he returning 65K records? I thought he was just searching through them... in which case the WHERE clause isn't going to help one iota.

    You should simply Index the fields you are searching or sorting to improve performance.

    The extra RAM will help performance system wide too
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  11. #11
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •