I have a question about "PRAGMA cache_size" if I use the default value(2000) and I use the default value for the page size, what is the max memory size sqlite can reach in a request?
Il 21/09/2010 19.31, Pavel Ivanov ha scritto: >> 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 > > -- Selea s.r.l. Michele Pradella R&D SELEA s.r.l. Via Aldo Moro 69 Italy - 46019 Cicognara (MN) Tel +39 0375 889091 Fax +39 0375 889080 *michele.prade...@selea.com* <mailto:michele.prade...@selea.com> *http://www.selea.com* _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
