Re: [sqlite] Re: speeding SQLite on a cross-join over two tables

2006-09-20 Thread P Kishor
Apologies for the misposting, a result of typos and several versions of these queries that I was trying out. See below for more responses -- On 9/20/06, Dennis Cote <[EMAIL PROTECTED]> wrote: P Kishor wrote: > Gentlefolks, .. > You have an error in the select statement inside your create view

Re: [sqlite] Re: speeding SQLite on a cross-join over two tables

2006-09-20 Thread Dennis Cote
P Kishor wrote: Gentlefolks, I tried my own steps as stated below, and failed rather miserably. I created everything as below, and ran an UPDATE yesterday mid-aft. Came back this morning, and by mid-morning it hadn't even budged. Killed the process, and tried a simple about 10 mins ago SELECT