Re: [sqlite] How to speed up a query between two tables?

2009-09-15 Thread Kermit Mei
On Tue, 2009-09-15 at 22:31 +1000, John Machin wrote: > On 15/09/2009 7:25 PM, Kermit Mei wrote: > > On Tue, 2009-09-15 at 17:37 +1000, John Machin wrote: > >> On 15/09/2009 4:47 PM, Kermit Mei wrote: > >>> > >>> sqlite> SELECT HomeDev.text, ZPhDev.id > >>>...> FROM ZPhDev > >>>...> INNER J

Re: [sqlite] How to speed up a query between two tables?

2009-09-15 Thread John Machin
On 15/09/2009 7:25 PM, Kermit Mei wrote: > On Tue, 2009-09-15 at 17:37 +1000, John Machin wrote: >> On 15/09/2009 4:47 PM, Kermit Mei wrote: >>> >>> sqlite> SELECT HomeDev.text, ZPhDev.id >>>...> FROM ZPhDev >>>...> INNER JOIN HomeDev ON (HomeDev.id = ZPhDev.id) >> Are you sure that you mea

Re: [sqlite] How to speed up a query between two tables?

2009-09-15 Thread Kermit Mei
On Tue, 2009-09-15 at 17:37 +1000, John Machin wrote: > On 15/09/2009 4:47 PM, Kermit Mei wrote: > > Hello community! > > > > I have two tables: > > > > HomeDev(id, text, icon) > > > > and > > > > ZPhDev(id,HomeDevId) > > > > Now, I must usually access(read-only) the items: > > > > sqlite> SE

Re: [sqlite] How to speed up a query between two tables?

2009-09-15 Thread John Machin
On 15/09/2009 4:47 PM, Kermit Mei wrote: > Hello community! > > I have two tables: > > HomeDev(id, text, icon) > > and > > ZPhDev(id,HomeDevId) > > Now, I must usually access(read-only) the items: > > sqlite> SELECT HomeDev.text, ZPhDev.id >...> FROM ZPhDev >...> INNER JOIN HomeDev ON

[sqlite] How to speed up a query between two tables?

2009-09-14 Thread Kermit Mei
Hello community! I have two tables: HomeDev(id, text, icon) and ZPhDev(id,HomeDevId) Now, I must usually access(read-only) the items: sqlite> SELECT HomeDev.text, ZPhDev.id ...> FROM ZPhDev ...> INNER JOIN HomeDev ON (HomeDev.id = ZPhDev.id) ...> ORDER By HomeDev.text; Then, How ca