Fastest access driver?

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Mikael Members Profile Find Members Posts Groupie Joined: 16 November 2002 Status: Offline Points: 151	Post Options Post Reply Quote Mikael Report Post Thanks(0) Quote Reply Topic: Fastest access driver? 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?

MadDog Members Profile Find Members Posts Mod Builder Group Joined: 01 January 2002 Status: Offline Points: 3008	Post Options Post Reply Quote MadDog Report Post Thanks(0) Quote Reply Posted: 24 March 2003 at 4:31pm
	Provider=Microsoft.Jet.OLEDB.4.0; i think, isnt it?


vdub Members Profile Find Members Posts Senior Member Joined: 23 February 2003 Location: United States Status: Offline Points: 275	Post Options Post Reply Quote vdub Report Post Thanks(0) Quote Reply 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

eaglesexec Members Profile Find Members Posts Groupie Joined: 02 December 2002 Status: Offline Points: 127	Post Options Post Reply Quote eaglesexec Report Post Thanks(0) Quote Reply 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.

vdub Members Profile Find Members Posts Senior Member Joined: 23 February 2003 Location: United States Status: Offline Points: 275	Post Options Post Reply Quote vdub Report Post Thanks(0) Quote Reply 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.
	Hardware reviews, Forum, Free advertising!!!!

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.