Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
DotNet
acad.assignment.mngr
academic
adonet
aspnet
aspnet.announcements
aspnet.build.controls
aspnet.caching
aspnet.datagridcontrol
aspnet.mobile
aspnet.security
aspnet.webcontrols
aspnet.webservices
clr
compactframework
component_services
datatools
distributed_apps
drawing
faqs
framework
framework.wmi
general
internationalization
interop
languages.csharp
languages.jscript
languages.vb
languages.vb.controls
languages.vb.data
languages.vb.upgrade
languages.vc
languages.vc.libraries
myservices
odbcnet
performance
remoting
scripting
sdk
security
setup
vjsharp
vsa
webservi.enhancements
webservices
windowsforms
windowsforms.controls
winforms.databinding
winforms.designtime
xml
  
 
date: Tue, 10 Jan 2006 11:58:03 -0800,    group: microsoft.public.dotnet.datatools        back       


ADO.net Code Contest   
I am sponsoring a contest to see if someone can come up with ADO.net code to 
insert records into a MS Access 2003 database faster than ADODB methods (MS 
ActiveX Data Object 2.x library).  My experiece has shown that I can write 
records to Access at least 4 times faster using ADODB methods in a Visual 
Studio 2003/2005 project as compared to any ADO.net methods.  I want to see 
if this is due to my ignorance or a problem with ADO.net and Access 2003 
databases.

From the link below, there is a test project available that has five methods 
of writing to an Access database, an ADODB method and 4 versions of ADO.net 
methods.  The time to write 30,000 records is timed for each method.  The 
code is written in VB.net.

There is a $100 reward to the first person who can use ADO.net methods that 
beat the ADODB methods working within the confines of the rules.  Note there 
is only one reward.

Please see the following link for full details.

http://www.kelbli.net/kb1/AdoNetContest.html

Thanks

Brian
date: Tue, 10 Jan 2006 11:58:03 -0800   author:   bdwest

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us