On Mon, Oct 27, 2014 at 11:08 AM, Stephan Beal <sgb...@googlemail.com> wrote:
> - TEMP tables get created in the MAIN db (assuming my memory of the docs > is correct), which means we can (though accidental misuse or carelessness) > end up filling up RAM with temporary tables (which we use regularly to > process large data amounts). This is my biggest concern with this approach. > In fact, it seems impossible to use any db _except_ the main one for temp tables: sqlite> .databases seq name file --- --------------- ---------------------------------------------------------- 0 main /home/portal/tmp/bar.db 2 foo /home/portal/tmp/foo.db sqlite> create temp table foo.baz(z); Error: temporary table name must be unqualified Which rules out use of a :memory: db has the local "main" - we make use of temp tables with arbitrarily large data sets. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
