On Mon, Oct 27, 2014 at 11:59 AM, Stephan Beal <sgb...@googlemail.com>
wrote:

> On Mon, Oct 27, 2014 at 11:53 AM, Hick Gunter <h...@scigames.at> wrote:
>
>> TEMP tables get created in database temp; which is located in "a file" or
>> "in memory" depending on the SQLITE_TEMP_STORE preprocessor symbol and the
>> pragma temp_store.
>>
>
> Which reveals my ignorance on the topic ;). IIRC we aren't using a
> specific temp store - we're using whatever's compiled in by default.
>
> So... maybe paying for a :memory: handle we "don't really use" won't be as
> painful as i first thought. Just add a pragma call to ensure that we're
> using disk instead of memory for temp store.
>

Follow-up: injecting a :memory: db as the first-opened DB turned out to be
a very small change (because the code was set up for that at one point),
and it turns out that using ATTACH for all three of our library-level DBs
gives us three or four minor features/benefits we didn't have before. e.g.
it was impossible to close one of the three DBs in one particular (and as
yet hypothetical) use case, but we can now attach/detach each one at will
without regard for the others or which one was opened first (as that role
is now taken by the :memory: placeholder).

All in all, making that change was a win.

Sidebar: it turns out there are some contexts where fossil does not allow
db.table qualification (namely (REFERENCES D.T) and (CREATE INDEX ... ON
D.T(F)) do not allow it), but that's a topic for another thread if/when it
becomes problematic (so far it's only a hypothetical problem, and not one
worth losing any sleep over).

@Gunter: Vielen Dank for clarifying where TEMP tables go: that
misunderstanding was why i migrated away from this setup in the first
place. (Und schoenen Gruss aus Muenchen!)

-- 
----- 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

Reply via email to