I have a question that I would be very happy to get some input about.
This is the case: I want to develop an application that reads records from
an Access database and then inserts these records into another database
(DB2, but that's unimportant for my question).
At this moment I first read all records into a VB Collection and after that
I loop through this collection and insert into the second db. My first
question is if someone have any clue if this procedure takes more/less time
compared to if I should have choosen a solution where I insert every record
into the other db after each one is read from the Access db (in that case I
don't need to use a Collection to store the data in). I can't see the reason
why my solution should take more time, but I'm not sure...
My second question: I have made a progress bar so I can monitor the read
operation from the Access db to the VB collection. The problem is that the
read operation is decreasing in speed all the way through. I guess that this
is due to that the available RAM decreases, any other explanations? Is there
any possibility to solve this or at least make it go faster? I didn't think
that the speed should decrease that much since the data I read into the
collection is only allocating approximately 2-6 MB?
VERY grateful for suggestions about these questions.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL