Dear Richard, Re: below, what happens if I change the sqlite3_limit to 10 when I have 20 attached. Will it complain? Can I shift the limit back and forth over time?
Thanks, Tim "The maximum number of attached databases can be lowered at run-time using the sqlite3_limit <https://www.sqlite.org/c3ref/limit.html>(db, SQLITE_LIMIT_ATTACHED <https://www.sqlite.org/c3ref/c_limit_attached.html#sqlitelimitattached>,size) interface." On Fri, Mar 4, 2016 at 8:11 AM, Tim Uy <tim at loqu8.com> wrote: > Well, probably only like a dozen, no worries. > > On Fri, Mar 4, 2016 at 8:07 AM, Simon Slavin <slavins at bigfraud.org> wrote: > >> >> On 4 Mar 2016, at 4:02pm, Tim Uy <tim at loqu8.com> wrote: >> >> > So Richard, theoretically, if you use negative numbers, you can get >> another >> > x2? >> >> Tim, >> >> are you actually considering attaching lots of databases at once ? This >> is a terrible idea. Every time you refer to an attached database SQLite >> has to find it. I don't know whether the list is hashed or not, but even >> hashed that means SQLite has to do a lot of work for every command. Plus >> reserve a lot of memory for the schemas for all these databases. >> >> Simon. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > >