just a bit of code to demonstrate sqlce insert performance on the desktop.
I'm using sqlce on the desktop to persist data as its the fastest thing I can find. Insert perfromance seems to top out at around 65,000records/sec on my laptop but it also seems to limited at this point by my hard drive speeds.
The sample code should be able to accept a dataTable, dataReader or dataset and persit to a sqlce database.
Also in the code is a small wrapper on the sqlce connectionstring (localconnectionstring). A
couple of the connectionstring parameters are essential to getting that extra 20% out of the engine. the primary setting seems to be the memory buffer as by default sqlce only takes uses 640k. Upping the memory to around 32768 seems to help for larger sets of data - beyond 32M I don't much improvment.
If you have questions, ask.