Results 1 to 7 of 7

Thread: Access Query Slow

  1. #1
    Join Date
    Mar 2009
    Posts
    4

    Access Query Slow

    Hi All.
    I am having access table containing 35000 records and 30 columns, when i use query to select one record from that table, query execution takes so much time.

    I have created an indexed field . Still execution is slow.
    Please tell me where i am wrong ?

  2. #2
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Welcome!

    First thing, have you backed up and then compacted the database with the table lately? (Be sure to make a backup first!)

    Is the database split?

    Is there an single index on the fields you are using with the selection criteria?

    Can you post the SQL for the query?
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

  3. #3
    Join Date
    Mar 2009
    Posts
    4
    Hello.
    This is not database split.
    I have to select any one of field based on any criteria.
    That means if my table is "customer_master" then i require address or city or code or any other information.
    But when i give query as "select city from customer_master where id =1 '" then this query takes too much time to execute if there are many records stored in my table. here "id" is my indexed field.

  4. #4
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Have you backed up and then compacted the database lately? If not, I would recommend this.
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

  5. #5
    Join Date
    Mar 2009
    Posts
    4
    I have compacted my database still its slow.

  6. #6
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    What version of Access are you using?

    Is the database on the local hard drive or on the network?

    Do you have a primary key set? Is "id" as the primary key?

    Can you post the SQL for the query?
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

  7. #7
    Join Date
    Mar 2009
    Posts
    4
    I am using Ms-access 2000.

    My database is located on novell server.

    My table's "id" fiels is primary key. but i havenot set it as primary key. its an autonumber field.

Posting Permissions

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