> 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?
I believe for Windows it's about 2Mb per database with shared cache mode on and 2Mb per connection with shared cache mode off. But "default page size" largely depends on VFS, OS and underlying file system. Pavel On Wed, Sep 22, 2010 at 6:02 AM, Michele Pradella <michele.prade...@selea.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
