Multi threading processing
Posted on 2011-03-17
I've recently come across the problem where after i generate a large list which contains tens of thousands records in the list, I want to insert the data into my database. What i did previously was using For each loop to process and insert the record into my database.
Normally for a small list it is fine that i can wait for 1 min or 2. but when comes to big lists I'll then have to wait much longer. I've done some testing on my machine, each record takes 3 secs to process on average.
so lets say i have 10000 records, that'll be nearly 8 hours which isn't reasonable as I might get even bigger lists.
so i did some search then found multithreading might help? what about multi-core processing? does VB support that or can i gain control on that? or is there some other ways i could improve the speed of processing? any comments would be appreciated.