Sounds to me like you're over normalizing things.
You'll never want to do a query spanning multiple minutes in your described setup? http://www.sqlite.org/limits.html The main limit that applies to your question is max of 64 tables in a Join. But you apparently never plan on joining tables, do you? Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Jaco Breitenbach [jjbreitenb...@gmail.com] Sent: Tuesday, August 09, 2011 8:05 AM To: General Discussion of SQLite Database Subject: EXT :[sqlite] Maximum number of tables in a data file Dear experts, 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. Regards, Jaco _______________________________________________ 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
