Using ADO with Access2000 & Access97


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Using ADO with Access2000 & Access97

  1. #1
    Vicky Diamond Guest

    Using ADO with Access2000 & Access97


    Hello Bill

    I just finished converting an application's database from Access97 to Access2000
    and noticed a significant performance downgrade, particularly when saving
    records. I am using ADO and scoured the code to reduce numbers of connections,
    plus many other code adjustmenst such as using serverside cursor with adcmdTable,
    just to improve the performance. I also checked the Access2000 database
    to make sure that all the indexes and relationships were still intact after
    the conversion. But, at the end of the day, after running the same application
    code against its Access97 database then running the same code against the
    same database after conversion to Access2000, I noticed a significant performance
    downgrade. Can you explain why this is occurring and what I can do to improve
    the performance?
    Share on Google+

  2. #2
    Kurtis Guest

    Re: Using ADO with Access2000 & Access97


    Vicky,

    Are you using ODBC to connect or an OLE DB provider?

    Kurtis

    "Vicky Diamond" <vicky.diamond@dewrsb.gov.au> wrote:
    >
    >Hello Bill
    >
    >I just finished converting an application's database from Access97 to Access2000
    >and noticed a significant performance downgrade, particularly when saving
    >records. I am using ADO and scoured the code to reduce numbers of connections,
    >plus many other code adjustmenst such as using serverside cursor with adcmdTable,
    >just to improve the performance. I also checked the Access2000 database
    >to make sure that all the indexes and relationships were still intact after
    >the conversion. But, at the end of the day, after running the same application
    >code against its Access97 database then running the same code against the
    >same database after conversion to Access2000, I noticed a significant performance
    >downgrade. Can you explain why this is occurring and what I can do to improve
    >the performance?


    Share on Google+

  3. #3
    Vicky Diamond Guest

    Re: Using ADO with Access2000 & Access97





    No. I am using ADO to connect to the OLEDB provider "Microsoft.Jet.OLEDB.4.0".
    Share on Google+

  4. #4
    Bill Vaughn Guest

    Re: Using ADO with Access2000 & Access97


    Well, Jet 4.0 switched to Unicode. This means the database itself is twice
    as large, it takes twice as many physical IOs to get the rows, they take
    twice the memory to cache and the processing takes somewhat longer to work
    with (convert back and forth and back again to/from unicode/ansi). Does this
    answer your question? To get the performance back... get MSDE.

    bv
    "Kurtis" <kurtism@kmgroup.net.nospam> wrote:
    >
    >Vicky,
    >
    >Are you using ODBC to connect or an OLE DB provider?
    >
    >Kurtis
    >
    >"Vicky Diamond" <vicky.diamond@dewrsb.gov.au> wrote:
    >>
    >>Hello Bill
    >>
    >>I just finished converting an application's database from Access97 to Access2000
    >>and noticed a significant performance downgrade, particularly when saving
    >>records. I am using ADO and scoured the code to reduce numbers of connections,
    >>plus many other code adjustmenst such as using serverside cursor with adcmdTable,
    >>just to improve the performance. I also checked the Access2000 database
    >>to make sure that all the indexes and relationships were still intact after
    >>the conversion. But, at the end of the day, after running the same application
    >>code against its Access97 database then running the same code against the
    >>same database after conversion to Access2000, I noticed a significant performance
    >>downgrade. Can you explain why this is occurring and what I can do to

    improve
    >>the performance?

    >


    Share on Google+

Similar Threads

  1. Replies: 1
    Last Post: 11-18-2002, 09:45 AM
  2. Replies: 3
    Last Post: 07-08-2002, 01:43 PM
  3. VB6, Access97 and ADO
    By moben in forum VB Classic
    Replies: 5
    Last Post: 01-03-2002, 09:24 AM
  4. ado & connectionstring for Access2000
    By Mandy in forum VB Classic
    Replies: 1
    Last Post: 06-27-2000, 04:09 PM
  5. Creating Access97 Database Tables Using ADO
    By Howard Lee in forum VB Classic
    Replies: 1
    Last Post: 04-04-2000, 04:35 AM

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