Speed of inserting data in table SqlServerCE

  • Thread starter Thread starter Brett Miller
  • Start date Start date
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
 
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.
 
Back
Top