On Wed, Jan 18, 2012 at 2:25 AM, David Henry <dav...@zickel.net> wrote:
> I asked this question on the sql_dev list which Richard Hipp told me that > this list was the proper place. > > > > I asked whether it is possible to execute SQLite in 80K of RAM. Well, I can > now tell you that you can, just about. > > My environment has no malloc so I used the MEMSYS5 method of internal > malloc, but any SQL query failed with "Out Of Memory". When I changed to > MEMSYS3, I was able to create a table, insert rows and do select. > > How much more I can do needs to be seen. > Disable the lookaside cache<http://www.sqlite.org/c3ref/c_config_getmalloc.html#sqliteconfiglookaside>by setting its size to zero. Reduce the default cache size <http://www.sqlite.org/compile.html#default_cache_size> to 10 pages or less. Set the maximum page size to 1024 bytes. With these changes, you should be able to run with memsys5. Memsys5 will work better than memsys3 because memsys5 is resistant to memory fragmentation. > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
