--- Henning Friese <[EMAIL PROTECTED]> wrote: > I'm using SQLite with the ADO .NET - Povider and I'd like to create a > database in memory, insert data into it and then save it to a file (for > performance reasons).
Your assumption may not be correct. This is counter-intuitive but, for newly created database files, a file-based SQLite database using coarse-grained transactions often performs better than a :memory: based database on Windows if you use a 4K page_size. In the cases where :memory: is faster, it's just by 10% in my experience. http://www.sqlite.org/cvstrac/tktview?tn=1790 http://www.sqlite.org/cvstrac/tktview?tn=1799 :memory: is faster if you're not using transactions. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
