On 10/14/19, szmate1618 . <szmate1...@gmail.com> wrote: > Hello everyone! > > After consulting the manual and doing a little googling I'm still unsure > about the runtime cost of a high SQLITE_MAX_ATTACHED setting. I admit 10 is > a reasonable default, but it's possible that I'll need a bit more. Can I > just set it to 125 right away and stop worrying about it, without terrible > performance degradation? Any help is appreciated, even if you just point me > to a relevant part of the source code. >
There is a small performance and memory penalty in sqlite3_prepare() (and its relatives) when SQLITE_MAX_ATTACHED exceeds 30. https://www.sqlite.org/src/artifact/40f81bb57b072340?ln=3065-3082 -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users