Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Location
    Gloucestershire, England
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Getting ODBC Table Link Into Memory (2000)

    I am sure I have read that there is something you can do to get a table into "memory" if you use it often, so reducing access time every time you call it, but after 45 minutes of trawling through all my notes, crib sheets and posts I just cannot find it!

    The problem I have is a query on an access table takes 29 seconds to return results the first time I run it and 2 seconds the subsequent times (presumably because the link to the table in access is already established). The query is in a front end database and the data in a back end.
    When I port the table to SQL Server 2000 (with all the relevant indexes, etc) and run the same query it consistently takes 7 seconds (a great improvement on the 29 seconds, but not so good against the 2!). I link to the table using ODBC. Creating an SQL view to replace the query is, unfortunately, not an option. I am looking to improve this response time somehow and wondered if loading the link in somehow would improve things.

    All advice welcomed!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Getting ODBC Table Link Into Memory (2000)

    See the thread starting at <post:=356,901>post 356,901</post:> for some suggestions. "Persistent connection" is the term to look for.

  3. #3
    New Lounger
    Join Date
    Mar 2004
    Location
    Gloucestershire, England
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Getting ODBC Table Link Into Memory (2000)

    Thanks for the link, Hans, I'll give it a go.

Posting Permissions

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