See https://sqlite.org/limits.html
11. Maximum Number Of Attached Databases The ATTACH statement is an SQLite extension that allows two or more databases to be associated to the same database connection and to operate as if they were a single database. The number of simultaneously attached databases is limited to SQLITE_MAX_ATTACHED which is set to 10 by default. The maximum number of attached databases cannot be increased above 125. The maximum number of attached databases can be lowered at run-time using the sqlite3_limit(db,SQLITE_LIMIT_ATTACHED,size) interface. So you have to compile a version of SQLite3 with a larger maximum limit. At runtime you cannot raise the limit above the default set by the SQLITE_MAX_ATTACHED compile-time parameter, you can only reduce the limit. -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On >Behalf Of Aydin Ozgur Yagmur >Sent: Thursday, 31 October, 2019 05:40 >To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> >Subject: Re: [sqlite] Multiple files for a single SQLite database > >How can it be raised to 125? >I tried to change with calling "sqlite3_limit(db_, SQLITE_LIMIT_ATTACHED, >125)" but there is no effect. >I still get "too many attached databases" exception. > > >On Wed, Oct 30, 2019 at 5:01 PM David Raymond <david.raym...@tomtom.com> >wrote: > >> "There's a limit, somewhere around ten, I think. Though you can >increase >> it by explicitly messing with limits and compilation options." >> >> Default is 10, can be raised to 125. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
