R S <[EMAIL PROTECTED]> wrote: > Thanks Clark. > > Another question, what if my Temp Table gets full (i.e. I am out of memory). > Would I get a SQLITE_NOMEM error? >
If you do PRAGMA temp_store=file then the TEMP tables are stored on disk. Actually, that's the default with the builds I put on the website. Though I just checked and it seems that if you build SQLite yourself using the configure script, then TEMP tables are stored in memory by default. You will need to use the pragma to store TEMP tables on disk. This should probably be considered a bug in the configure script. (Later: fixed using check-in [2748]) If you use the --enable-tempstore=no option on the configure script, it seems to make TEMP tables go to disk by default. (Later: This is now the default.) -- D. Richard Hipp <[EMAIL PROTECTED]>
