sqlite

< optimization < scaling < scalability < performance < web < tools < .net <
TwitterFacebook
Get flash to fully experience Pearltrees
http://web.utk.edu/~jplyon/sqlite/SQLite%5Foptimization%5FFAQ.html

SQLite Optimization FAQ

This FAQ is an incomplete summary of my experiences with speed-optimizing an application that uses the SQLite library.
On my current project, we’re successfully using SQLite for in-memory testing with NHibernate / Castle.ActiveRecord . This makes tests that run against the database a lot faster than if we ran them against SQL Server. NHibernate’s pluggable driver / connection provider model makes this fairly painless, but there are a few gotchas in the technical details that are worth calling out. http://alexscordellis.blogspot.com/2008/12/using-sqlite-for-fast-database-testing.html

Using SQLite for fast database testing – technical gotchas and w

http://sqlite.phxsoftware.com/ Announcement The folks at SQLite.org have taken over ownership of the System.Data.SQLite project. New releases can be found at the new site, System.Data.SQLite.org

System.Data.SQLite