On 27 Apr 2013, at 2:21am, Paolo Bolzoni <paolo.bolzoni.br...@gmail.com> wrote:
> The idea of temporary tables in-memory is nice, but I do not know how > to apply it. > I see in the documentation I can use the TEMP in CREATE TABLE, but I am not > sure of the effect. Temporary tables are a different thing. Those are just tables which are automatically deleted when you close the connection. You can make those in memory or on disk. > Does it mean that the table is created in memory and it is lost in > sqlite3_close? Yes. Here's something about them: <http://www.sqlite.org/inmemorydb.html> The basic advantage is that they're extremely fast. Unless your memory is full and being paged out to disk. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users