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...

  • ...
    Black Duck offers a free trial so you can discover if there are open source vulnerabilities in your code
  • ...
    learn about Open Hub updates and features on the Open Hub blog
  • ...
    there are over 3,000 projects on the Open Hub with security vulnerabilities reported against them
  • ...
    compare projects before you chose one to use

 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