ADO Jet 4.0 performance problem vs Jet 3.51 
Author Message
 ADO Jet 4.0 performance problem vs Jet 3.51

I have created an Access database with approximately 100 fields and am
using Visual Basic 6 to access the file and am using DataEnvironment ADO
connection.

If I use Jet 3.51 DB provider then the application works quickly and the
recordset opens in 1 to 2 seconds on an average PC which is what I would
expect.

If I change the provider to Jet 4.0 the same recordset command (requeries
etc etc) all take between 10-20 seconds at least.

If I switch back to Jet 3.51 then it is fine again.
My smaller databases (with less than 50 fields) are ok with Jet 3.51 and
4.0 so it seems to be something to do with the quantity of fields.

Any idea's anyone as its driving me mad and I obviously would like to use
Jet 4.

Thanks in advance
Simon



Tue, 09 Jul 2002 03:00:00 GMT  
 ADO Jet 4.0 performance problem vs Jet 3.51
Simon,

What happens if you upgrade the database itself to version 4.0?

--
Regards

Carsten Thomsen
MCSE/VB Programmer & Analyst

PLEASE post ALL replies to the newsgroup(s) so we can all benefit from the
discussion!


Quote:
> I have created an Access database with approximately 100 fields and am
> using Visual Basic 6 to access the file and am using DataEnvironment ADO
> connection.

> If I use Jet 3.51 DB provider then the application works quickly and the
> recordset opens in 1 to 2 seconds on an average PC which is what I would
> expect.

> If I change the provider to Jet 4.0 the same recordset command (requeries
> etc etc) all take between 10-20 seconds at least.

> If I switch back to Jet 3.51 then it is fine again.
> My smaller databases (with less than 50 fields) are ok with Jet 3.51 and
> 4.0 so it seems to be something to do with the quantity of fields.

> Any idea's anyone as its driving me mad and I obviously would like to use
> Jet 4.

> Thanks in advance
> Simon



Wed, 10 Jul 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Jet DB Performance (Jet 3.51 vs. Jet 4.0)

2. Jet 3.51 vs Jet 4.0 vs MSDE

3. Ms Jet 4.0 VS Jet 3.51 problem loading data

4. Jet 4.0 vs. Jet 3.51

5. MS Jet 3.51 vs Jet 4.0

6. Jet 3.51 vs JET 4.0

7. JET4.0 Performance Problem vs Jet 3.51

8. Is Jet 4.0 slower than Jet 3.51?

9. Jet 3.51 to Jet 4.0

10. Jet 4.0 much slower than Jet 3.51

11. Converting JET 3.51(97) To Jet 4.0(2000) Using DAO In VB 5

12. Jet 3.51 or Jet 4.0?

 

 
Powered by phpBB® Forum Software