Speed Comparison Test

[yu217171]

Hi everyone,

I need your opinion with some speed enhancements. Currently, I am grabbing data from an IIS log file and then parsing it to get the data that I need. I then take that data and insert it into a small Access database.

The problem is I call my database insert function as many times as there are inserts. Would implementing a datatable solution speed up the process? I insert about 3000 records on average.

Keith

 

[Isadore]

Keith: My guess is that you'll probably save time and resources by working outside the mdb.

If you haven't already you might want to take a look at DataTable.GetChanges Method ()

Gets a copy of the DataTable that contains all changes made to it since it was loaded or AcceptChanges was last called.

Just a thought on this; haven't faced this problem.

 

[yu217171]

Isadore,

Thanks for replying. Would it be more efficient to use a DataTable object or would using an array be sufficient? Either way, I'd have to iterate through a collection to insert the data right?

Keith