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
