RE: [sqlite] Subject: Re: [sqlite] Let us make SQLite more powerful

2003-12-30 Thread Mrs. Brisby
On Tue, 2003-12-30 at 06:46, Steve O'Hara wrote: > My understanding is that logically, by their very nature, joins are always > likely to be slower than single table queries - I thought that this was a > given downside to normalisation or am I incorrect? Maybe the downside is > not pronounced in S

RE: [sqlite] Subject: Re: [sqlite] Let us make SQLite more powerful

2003-12-30 Thread Steve O'Hara
> -Original Message- > From: Mrs. Brisby [mailto:[EMAIL PROTECTED] > Sent: 29 December 2003 23:41 > To: Yogesh Vachhani > Cc: [EMAIL PROTECTED] > Subject: Re: [sqlite] Subject: Re: [sqlite] Let us make SQLite more > powerful > > > On Sat, 2003-12-27 a

Re: [sqlite] Subject: Re: [sqlite] Let us make SQLite more powerful

2003-12-29 Thread Mrs. Brisby
On Sat, 2003-12-27 at 07:16, Yogesh Vachhani wrote: > > Why exactly do you think the JOIN operator is the wrong tool for > > this? > > I feel JOIN operations are taxing on the Process as well as on RAM > and HDD (in form of temporary files) All right then. SQLite doesn't produce temporary files f