.MDB access slow in C# Upgraded to VS 2005 - Now old c# project VERY VERY slow handling Access .mdb files
Posted on 2006-11-24
I have an application which manipulates a fairly large Access database (25000 records, 51Mb). Code snippets include:
Many lines of code missing, just to give you an idea of the code used....
CONN_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DATABASE_NAME;
oCONN = new OleDbConnection(CONN_STRING); // Set oCONN object
oCONN.Open(); // Open the oCONN
oDA_new = new OleDbDataAdapter(sSQL,oCONN);
oDS_new = new DataSet(); // Create the DataSet
DataRow oDR = oDS_new.Tables["Products"].NewRow();
oCB_new = new OleDbCommandBuilder(oDA_new);
With the old VS a database with a few thousand updated records would save in around 60 seconds.
With VS2005, the same application takes about 4 hours !!!!!
I ahve not changed any references between versions. Have you any idea why this has slowed so much ? I am now rewritting the program using SQL Server 2005 but until the program is fully developed I wish to use the old version without the 12 hour turn-around !
Fully qualified answer needed and positive outcome to receive points. Thankyou