Re: Please increase the default for SQLITE_MAX_VARIABLE_NUMBER
Simon Slavin <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
On 4 Feb 2020, at 6:27pm, Alex Bronstein <[email protected]> wrote: > In such cases, you can easily end > up with more than 999 parameters. I'm curious. Can you show us some place where using 999 parameters is a reasonable way to use SQLite ? > PostgreSQL and some other databases support a 16 bit parameter count (64K parameters). Given current memory availability, can sqlite's default be raised to something similar to that? Might help to know that using the 64K'th parameter would cause SQLite to maintain a list 64K items long. It's an array, not a key/value lookup. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users