On 18 Apr 2011, at 2:44pm, Adam DeVita wrote:

> What happens if you insert more than your RAM size into an in memory
> database?

Windows doesn't really keep all its memory in actual RAM.  It uses a 'page 
file' to allow it to send data it's not actually using right now to disk, and 
call it back when it needs it.  You generally allow it to use more paging space 
than you have actual space in RAM.  Setting the amount of disk space it can use 
for paging is a system setting.  For instance, this is how it's done in Windows 
XP:

<http://support.microsoft.com/kb/314482>

As you can see, you can set a specific size.

So your question becomes '... more than your page space ...'.  But the answer 
is what Pavel wrote: the function you called with INSERT returns a SQLite 
result code indicating failure of some appropriate kind.  You should deal with 
that result just as carefully as you'd deal with any other unexpected non-zero 
result code.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to