Update Access database from a DataSet takes way too long

Posted on 2006-10-24
Medium Priority
Last Modified: 2012-06-22
I am using C# to make some data sets for an Access database.  When I save a data set (using an OdbDbDataAdapter) that has 3500 rows added to an originally empty table it takes 45-50 seconds to do the insert.  I was using the command builder to make the insert command so I thought I would make my own stored proc and try that - it didn't help.  I also need to save a set of 58,000 records and it takes 15 minutes or so using the command builders insert command and, having tried making my own for the other, I'm guessing it's not going to help there either. That seems way out of line - what is going on?  What can I do to speed this up.  It's almost useless. I've also done an update of one field in a data set and saving it also takes the same (too much) time.

Question by:thresholds
LVL 11

Accepted Solution

anyoneis earned 500 total points
ID: 17801365
I am getting 5000 records updated in 12.5 seconds. They are small - three columns. I could not find anything that would increase this performance. Sorry!

LVL 15

Expert Comment

ID: 17804191
Access itself is slower, you could try finding a different database, something that is faster, MySQL, SqlServer Express, something like that.

If you are still really hurting, you could possibly go down the path of trying to insert the data in VB6 with ADO and wrapping that with your c# class, but I would expect this to be even slower.   The size of your 58,000 rows is probably the real issue, it's just more than what access is able to handle easily.

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
In the video, one can understand the process of resizing images in single or bulk. Kernel Bulk Image Resizer is an easy to use tool for resizing large number of images. One can add and resize multiple images with this tool in single go. The video sh…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question