> Keep in mind that sqlite has a limit of 32 open databases. 32 _attached_ databases, not opened. With different sqlite3* handlers you can open as many databases as you want (and your memory permits).
Pavel On Thu, Apr 7, 2011 at 6:05 AM, Eduardo <nec...@retena.com> wrote: > At 18:11 06/04/2011, you wrote: >>Thanks Stephan and Simon - I kind of figured it was one of those "how >>long is a ball of string" questions, but I just wanted to check there >>weren't any particular gotchas to watch out for. >> >>Regarding the separate files, it seems the best way to go. Each >>individual table could get pretty large (possibly several gb), and the >>one table per DB approach means that should any one file get damaged in >>some way, only that one set of data would be lost. > > Keep in mind that sqlite has a limit of 32 open databases. > >>-- >>Paul Roberts > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users