bulk load for inserts in Sql Compact?

Posts   
 
    
mvording
User
Posts: 19
Joined: 04-Oct-2008
# Posted on: 16-Jun-2010 03:19:45   

Hello:

I have an application running on Compact Framework 3.5 and using SqlCompact and LLBLGen 2.6 (latest released version) as the data store and O/R mapper.

The issue I'm having is that adding tens of thousands of records to the database takes an extremely long time (hours). The download of the data over the internet is not time consuming.

Is there some way to "bulk load" or do an insert to an empty table in a speedier fashion with LLBLGen and SqlCompact?

Thanks in advance, Matt

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 16-Jun-2010 06:57:11   

Could you please explain how exactly are you saving those thousand of records? What ware you doing exactly?

David Elizondo | LLBLGen Support Team