> Is Sqlite somewhere caching data? If so, how do I disable it or decrease the > amount of cached data?
http://www.sqlite.org/pragma.html#pragma_cache_size Pavel On Tue, Sep 21, 2010 at 1:24 PM, "Richard Wähnelt" <deslo...@web.de> wrote: > Hello there, > > I hope, someone can help me with the problem I'm having. > > The whole picture: > I'm running a .NET 3.5 application using System.Data.SQLite as provider. > Inserting Data happens via Entity Framework and Linq to Entitites. For > querying data I use DataAdapter/DataView/DataGridView combination with > SQL-Strings. The application runs 24/7. > I created the database with just plain DDL commands and added two triggers, > no changes to configuration were made. The size of the sqlite file is about > 100 MB and there is data being inserted every 2 seconds. Each insert triggers > either one of the triggers. After a while (considerably short time of 1 day) > the memory consumption of my application as seen in Windows Task Manager > grows from about 60 MB to 150 MB. As far as I can tell, this doesn't come > from my application directly. > This becomes a problem because the system is only equipped with Intel Atom > 1.6 GHz and 1 GB RAM (no other applications are running) and after a while my > application slows down and doesn't compute input as fast as needed. > > > My question is now: > Is Sqlite somewhere caching data? If so, how do I disable it or decrease the > amount of cached data? > > Or does this maybe happen in combination with the DataConnections for > EntityFramework and/or DataAdapter and do I need to reset them somehow to > clear memory? > > Any help is greatly appreciated. > > Kind Regards > deslokrw > ___________________________________________________________ > WEB.DE DSL SOMMER-SPECIAL: Surf & Phone Flat 16.000 für > nur 19,99 €/mtl.!* http://produkte.web.de/go/DSL_Doppel_Flatrate/2 > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users