Database Headache


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Database Headache

  1. #1
    Bill A Murray Guest

    Database Headache


    Okay,
    If anyone could just point me in the right direction - I would really appreciate
    it.
    I have a client with a major problem with data access. Retrieval times
    for getting a high number of records out of an Access '97 database are somewhere
    in the neighborhood of 7-8 MINUTES.
    This VB6 based software was written using DAO. No relationships are setup
    directly in Access - just uses foreign keys to sort the data.
    Any ideas?

    bam@vcgit.com

  2. #2
    Chris Ross Guest

    Re: Database Headache

    Hi Bill,

    A couple questions come to mind when I read your post. Namely - how many
    users are accessing the db? Is it being connected to locally or on a
    network? How big is the database? Is the long data retrieval time just for
    one SQL statement, or is it just slow overall?

    Regards,
    Chris Ross

    Bill A Murray <bam@vcgit.com> wrote in message
    news:38e1912a@news.devx.com...
    >
    > Okay,
    > If anyone could just point me in the right direction - I would really

    appreciate
    > it.
    > I have a client with a major problem with data access. Retrieval times
    > for getting a high number of records out of an Access '97 database are

    somewhere
    > in the neighborhood of 7-8 MINUTES.
    > This VB6 based software was written using DAO. No relationships are

    setup
    > directly in Access - just uses foreign keys to sort the data.
    > Any ideas?
    >
    > bam@vcgit.com




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center