Re: [sqlite] Multiple databases vs. Multiple tables.

2010-10-26 Thread Dariusz Matkowski
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rich Shepard Sent: Tuesday, October 26, 2010 10:59 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Multiple databases vs. Multiple tables. On Tue, 26 Oct 2010, Dariusz Matkowski wrote: > Queries will be done across

Re: [sqlite] Multiple databases vs. Multiple tables.

2010-10-26 Thread Rich Shepard
On Tue, 26 Oct 2010, Dariusz Matkowski wrote: > Queries will be done across the servers to aggregate the content. I am > concern about the locking mechanism, if I write to the single database and > I represent the servers as tables I will have no access to read the other > servers/tables, but if I

Re: [sqlite] Multiple databases vs. Multiple tables.

2010-10-26 Thread Dariusz Matkowski
databases vs. Multiple tables. On Tue, 26 Oct 2010, Dariusz Matkowski wrote: > Only one user (the browser). The DB is on a device the same place where > the user (Browser) is. A process will collect the information about the > servers and their contents and story it to the DB at the same

Re: [sqlite] Multiple databases vs. Multiple tables.

2010-10-26 Thread Rich Shepard
On Tue, 26 Oct 2010, Dariusz Matkowski wrote: > Only one user (the browser). The DB is on a device the same place where > the user (Browser) is. A process will collect the information about the > servers and their contents and story it to the DB at the same time the > user may ask for the contents

Re: [sqlite] Multiple databases vs. Multiple tables.

2010-10-26 Thread Dariusz Matkowski
- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rich Shepard Sent: Tuesday, October 26, 2010 9:24 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Multiple databases vs. Multiple tables. On Tue, 26 Oct 2010, Dariusz Matkowski wrote

Re: [sqlite] Multiple databases vs. Multiple tables.

2010-10-26 Thread Rich Shepard
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 assu

[sqlite] Multiple databases vs. Multiple tables.

2010-10-26 Thread Dariusz Matkowski
Question, 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 informati