On 15 Dec 2017, at 4:30pm, x <[email protected]> wrote:

> Suppose I execute “attach :memory: as mem” and then create a table in mem 
> that requires more space than the available RAM can hold what will happen?

The problem would not happen when you create the table.  SQLite reserves only a 
little space for each table.  It is far more likely to happen when you add a 
new row to an existing table.

SQLite relies on your OS to implement memory handling.  If your operating 
system implements virtual memory then it’s used.  If not you get either 
SQLITE_FULL or SQLITE_NOMEM depending on exactly what SQLite is doing when it 
runs out of space.

Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to