Re: [sqlite] Virtual Table and the xBestIndex

2011-02-26 Thread Dariusz Matkowski
ite.org] On Behalf Of Jay A. Kreibich Sent: Friday, February 25, 2011 11:00 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Virtual Table and the xBestIndex On Fri, Feb 25, 2011 at 09:30:00PM -0500, Dariusz Matkowski scratched on the wall: > I am trying to implement a simple

Re: [sqlite] Virtual Table and the xBestIndex

2011-02-26 Thread Dariusz Matkowski
al Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jay A. Kreibich Sent: Friday, February 25, 2011 11:00 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Virtual Table and the xBestIndex On Fri, Feb 25, 2011 at 09:30

[sqlite] Virtual Table and the xBestIndex

2011-02-25 Thread Dariusz Matkowski
Hi all, I am trying to implement a simple virtual table that reads in a file with two columns and "::" separator. My question is: is it necessary to implement xBestIndex to run a simple where clause queries? Thank you. - This t

Re: [sqlite] Degrees of separation

2010-12-03 Thread Dariusz Matkowski
Phobic - Original Message - From: Simon Slavin [mailto:slav...@bigfraud.org] Sent: Friday, December 03, 2010 06:36 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Degrees of separation On 3 Dec 2010, at 11:14pm, Drake Wilson wrote: > Another would be to > rewrite the

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 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 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

[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