On Sat, 7 Mar 2009 14:02:36 -0800 (PST), baxy77bax <b...@hi.htnet.hr> wrote:
> >hi, > >i need help with attaching databases. in my last post i recived some >valuable info on limitation of attached databases (Thanx !!). since i'm >using perl (its DBI) all modifications like cache_size, max page number , >journal size ... i've introduced through PRAGMA but for limitations on >number of attached databases, there is no pragma statement :confused: (or >al least i can't see one :-/)and i would need to some how change the default >value from 10 to 30 databases. Indeed there is no PRAGMA to increase the maximum, just one to reduce it. >can anybody help me with that ? Suggestions: 1) Open them directly in Perl, not by attaching them to the main database 2) Don't open them all at the same time, but use them one by one. 3) Combine your databases into one big one. 4) Change the source and rebuild DBI >thank you HTH -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
