Re: Is the table created by "create temp table" in the database file or in memory?
sub sk79 <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CA+gZn2k-R4vC+wtBdYW18c-aQ9iwF1W2TBH9_DAK5g-9mo4Drg@mail.gmail.com> |
Also these links which maybe easier to grok: https://sqlite.org/tempfiles.html <https://sqlite.org/tempfiles.html#tempstore> (sections 2.6 and 3) https://sqlite.org/tempfiles.html#tempstore -Neal On Sat, Feb 1, 2020 at 10:09 AM J. King <[email protected]> wrote: > On February 1, 2020 10:03:28 a.m. EST, Peng Yu <[email protected]> > wrote: > >But it doesn't explain what is "the temp database". Is it an actual > >database file? Or it is just a in-memory database? > > > It depends. See <https://sqlite.org/pragma.html#pragma_temp_store> for > details ans links to further reading. > -- > J. King > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users