4 ms·
>Increase the default upper bound on the number of parameters from 999 to 32766. I don't want to know the use case for this. Keep rocking on, SQLite. It's the
by trashburger 6y ago
>Increase the default upper bound on the number of parameters from 999 to 32766.
I don't want to know the use case for this.
Keep rocking on, SQLite. It's the first tool I reach for when prototyping anything that needs a DB.
- oefrha 6y agoSimple. Bulk insert with a 999-parameter limit is just painful; if each entry has 9 columns, you can’t even insert 112 rows at once. In practice distros already compile with higher default; e.g. Debian compiles with -DSQLITE_MAX_VARIABLE_NUMBER=250000, still way higher than this new default.
- abraae 6y agoWhat's the point? Inserting batches of 1000 rows at once, or even 10k rows at once is hardly any faster overall than using batches of 100 rows, assuming there are no delays in presenting the batches to the DB.
- Carpetsmoker 6y agoIt's just easier: I won't have to split queries with 1,500 parameters in two because of some limit.
- dtf 6y agoFor instance, you might want to update a large subset of rows via WHERE id IN (?,?,?,...) instead of WHERE id IN (SELECT ...)