Slow loading of sqlce database from sqlserver

  • Thread starter Thread starter mikeb
  • Start date Start date
M

mikeb

I'm trying to load a sqlce database that resides on my ppc. I'm taking
records from a sql server, loading them into a dataset via a stored prcedure
call, and then cycling through the dataset to load the data into sqlce.

It take a very long time to load from the dataset to the sqlce - is this
what I should expect?

I remember looking into some sync method that was recommended to me a while
back - but since my databases (sqlserver and sqlce) doesn't match exactly I
don't think it woujld have worked.

What is the best way to get data from a sql server stored procedure call
into a sqlce database?

thx, -Mike
 
SQL CE is notoriously slow when inserting data through a SQL command (even a
parameterized and prepared INSERT command will be slow). The best approach
for bulk inserting is using a base table cursor through the OLE DB layer,
but this is not readily available to the CF (I'm working on it). I have been
working on the subject of porting data back and forth and you can find some
products that may help you on my site - www.primeworks.pt
 
Back
Top