0
I Use This!
Activity Not Available

Project Summary

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.

Tags

No tags have been added

In a Nutshell, sqlce_perfDemo...

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

This Project has No vulnerabilities Reported Against it

Did You Know...

  • ...
    in 2016, 47% of companies did not have formal process in place to track OS code
  • ...
    by exploring contributors within projects, you can view details on every commit they have made to that project
  • ...
    65% of companies leverage OSS to speed application development in 2016
  • ...
    you can subscribe to e-mail newsletters to receive update from the Open Hub blog

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

Community Rating

Be the first to rate this project
Click to add your rating
   Spinner
Review this Project!
Sample ohloh analysis