Jaco Breitenbach <jjbreitenb...@gmail.com> wrote: > Can anyone please tell me if there is a limit to the number of tables that > can be held in a single data file? I am considering an application that > will require a table for every minute in a day, i.e. 3600+ tables in a > single database or data file.
First, there are 1440 minutes in a day. Second, you should be able to create this number of tables: if the limit exists, it's likely much higher than that. Finally, I predict that the schema you envision would be very awkward to work with. Have you considered a single table having MinuteOfDay as an extra column? -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
