Speed of inserting data in table SqlServerCE

B

Brett Miller

I have written some proof of concept code that adds records to a table,
utilizing SqlServerCe, using a parameters in a insert statement.

I am forced to read data from a BinaryStream (in the form of a file), assign
values to the parameters and execute the sql insert statement from within a
while loop

The table contains 11 fields, and it currently takes over two minutes to
read 4500 records...

This is maddness, as I am porting from an old application, and I can
accomplish the above in about 2 seconds using my old code (written in OPL)
using a device thats 4x slower than the one I'm currently developing on.

Anybody have an idea how to speed this up? or mybe a sneaky workaround... :)

Regards BM
 
E

Earl

I think they call it SQLCE 3.0 ... sometime soon. It's a known issue that
SQLCE is dog-slow, and every bum and his brother has been coming out with a
pocket-DBMS, so it appears that Microsoft is finally going to do something
about it.
 

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

Speed of inserting data into a table SqlServerCE 6
SqlCeParameter Issues NullReferenceExeception 1
Inserting records from one database into identical table in another datrabase 7
DataAdapter and inserting into a table with a AUTO Counter field? 3
Sorting records in an Access table for real 2
Strongly Typed DataSets and "Refresh the data table" Option 6
Inserting Rows in another table automatically 1
Trying to speed up the writing of data 2

Top