Import Data from text file into sql DB using CSLA
- by New Developer
I am trying to import data from ~ Delimited Text file into SQL Server using CSLA.
My text file has 92,000 records in it.
Here are the issues i am having with the import
When i create a BusinnessListBase .new and add all my records to it,
it gives me a "Out of meory exception". So to fix it i create a new
bussinessbase object and save it. this works fine and is much faster
too. It takes 15 minutes
I have to run my program again and check for any changes and hence update them, this is where it takes too much time.
Is there any alternative way to speed up my import?