SQLite = AWESOME free database
Video Introduction:
SQLite is known to be embedded in:
* Mozilla Firefox, the leading open-source web browser, for some databases in the user profile.
* Ruby on Rails, default database in Ruby on Rails 2.0 release.
* Android, the mobile phone development kit created by Google, to store user data.
* Mac OS X, starting with version 10.4 (Tiger), as a persistence layer of the Core Data API
* musikCube, a low weight music player, for querying the media library in dynamic playlists.
* Google Gears, providing local DB facilities to javascript apps.
… perhaps the most deployed database in the world and some are well-known.
My local results with System.Data.SQLite …
Inserting using CommandBuilder and DataAdapter
-> (10,000 rows) …
-> Insert Ends in 203 ms … Commits in 375 msInserting using CommandBuilder and DataAdapter
->(with identity fetch) (10,000 rows) …
-> Insert Ends in 375 ms … Commits in 328 msFast insert using parameters and prepared statement
-> (100,000 rows) Begins …
-> Ends in 1203 ms … Commits in 359 msUser Function iteration of 120003 records in 203 ms
Raw iteration of 120003 records in 94 ms
Intrinsic Function iteration of 120003 records in 94 msUser (text) command executed 307429 times in 1 second.
UserFunction command executed 437927 times in 1 second.
Intrinsic command executed 626278 times in 1 second.
Intrin (txt) command executed 485891 times in 1 second.
Raw Value command executed 677517 times in 1 second.UserAggregate executed 16 times in 1 second.
