The built-in limit in code for attach is 30 (2 reserved for MAIN and TEMP, plus 30 bits more, to fit within a 32-bit integer type), which can be expanded by setting the macro SQLITE_MAX_ATTACH to the higher number when compiling sqlite3.c . The limit is per connection handle.
There are, of course, process limit maximums, and operating system maximums, if you anticipate having a very large number of connection handles and processes. --andy On 10/11/07, Andre du Plessis <[EMAIL PROTECTED]> wrote: > > I know that the limits page says that the limit is 10 by default, I > would just like to know if the limit is per connection handle or global > for the module? > > > > Thanks. > >