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
>>
>
>

Reply via email to