2012/1/1 Baruch Burstein <bmburst...@gmail.com>: > I need a file format to hold a bunch of resources for my program. I thought > of using SQLite. However, I am debating two formats. The > more convenient one for me would put every few resources in > a separate table. However, this would result in small tables. Am I right > that this is very inefficient in SQLite? The other option would be to put a > bunch of unrelated resources in one table. Is this more efficient?
It is preferable to have fewer large tables, mainly due to ease of maintenance, but in the case of independent data that can be otherwise. Best to try both. What count of tables are we talking? Hundreds or thousands are not a problem. -- Kit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
