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