On 9 Nov 2011, at 12:08am, Gabor Grothendieck wrote: > If "SELECT ?500000" allocates 500000 * 72 bytes of memory then how > does that relate to SQLITE_MAX_VARIABLE_NUMBER? > SQLITE_MAX_VARIABLE_NUMBER did not seem to enter the calculation at > all.
In the above case, SQLite was compiled with SQLITE_MAX_VARIABLE_NUMBER = 500000. It's a limit, rather than operational use. Setting a lower value for SQLITE_MAX_VARIABLE_NUMBER means your user can't suddenly cause SQLite to demand 36 Meg of memory. This can be extremely important for embedded systems where such a demand could crash the entire device. It would be better to crash just the process which is trying to use SQLite. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
