Web Wiz Forums - Fastest access driver?

Print Page | Close Window

Fastest access driver?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=1300
Printed Date: 30 March 2026 at 7:50am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Fastest access driver?

Posted By: Mikael
Subject: Fastest access driver?
Date Posted: 24 March 2003 at 4:30pm

Diffrent access-db drivers:
DRIVER={Microsoft Access Driver (*.mdb)};
Provider=Microsoft.Jet.OLEDB.3.51;
Provider=Microsoft.Jet.OLEDB.4.0;

Which driver is the fastest one?

Replies:

Posted By: MadDog
Date Posted: 24 March 2003 at 4:31pm

Provider=Microsoft.Jet.OLEDB.4.0; i think, isnt it?

-------------
http://www.iportalx.net" rel="nofollow">

Posted By: vdub
Date Posted: 24 March 2003 at 5:50pm

strCon = "DRIVER={Microsoft Access Driver (*.mdb)}

This page was generated in 1.0195 seconds

strCon = "Provider=Microsoft.Jet.OLEDB.4.0

This page was generated in 1.1602 seconds

Server stats

ASUS P2BF
Cyrix 600Mhz (With Slot adap.)
384Mb PC-133
20Gb IBM 75GXP (Boot)
10Gb Fujisu (websites)
Windows 2000 Server SP3

Workstation stats

ASUS A7V (Full Raid Hack)
AMD 1Ghz@1.3Ghz
512Mb PC-133
2X Maxtor 20Gb 7200RPM (Raid 0)
Windows XP SP1

I ran the test on my workstation using DNS to access my Dev. server

Hope this helps. As soon as ver 7 gose live I will run this test on my live server 800Mb Dual P-III 1Gb Mem

Posted By: eaglesexec
Date Posted: 24 March 2003 at 6:05pm

ummm did u just run it once or take an avrg of 10-20 tries? cuz let me tell you once or twice means nothing really...

-------------
A good plan, violently executed now, is better than a perfect plan next week. -General George S. Patton.

Posted By: vdub
Date Posted: 24 March 2003 at 6:53pm

I have been testing it for weeks

Honestly even thow the numbers where highter with the jet 4 it feals faster.

-------------
http://www.CyberCPU.net - Hardware reviews, Forum, Free advertising!!!!

Posted By: WebWiz-Bruce
Date Posted: 25 March 2003 at 2:55am

In theory the Jet 4 driver is faster than the generic Microsoft Access Driver as it does one less hit on the registery when in use.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting