fast INSERT to SDF-file

V

Viki

Hi,

I have table with 100 000 records and I need to fill this table to
SDF-file. I use INSERT with using parameters, but it takes 40 minutes.(WINCE
4.20, 400MHz, 128MB)

Does anybody know faster solution?

Thanks

Viki
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy table from sdf file to another sdf file 2
sqlserverCE sdf 9
how to copy MS Access mdb file to PPC as SQL CE sdf file 1
HOW TO LOAD *.SDF DURING THE TEST DATABASE APPLICATION IN WM 5.0 1
How do I use autoincrement on the primary key in a table in sdf file 2
Fasr retreival of data from .sdf file using SQL CE 3
Importing bulk Data to SQL CE (insert/update) 2
Database woes in compact framework. Attempting to add contents oflistview to database. 1

Top