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

Reply via email to