On Tue, 26 Oct 2010, Dariusz Matkowski wrote: > in your opinion is it better (performance, maintainability etc...) to > have multiple databases or multiple tables. The problem I am facing is as > follows. I have many media servers containing a large amount of images > music and videos, let's assume 5. I would like to gather the information > (metadata, thumbnails, location etc) and story it in the database. I will > also have a GUI/Browser that will display that information. Now, the > question is it better to use multiple databases, each server = one > database or each server = one table.
Daiuusz, I suggest you're asking the wrong questions. How many simultaneous users will access data in the database? Will the database be stored on one server and accessed across the network? It might be that for your application SQLite is not the appropriate tool. Rich _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users