*** 353,358 **** --- 353,372 ---- way; which is the choice way to determine a subset of data that doesn't satisfy criteria contained in another table. + In my experience I have found 'NOT EXISTS' (or is it 'NOT IN') to be extraordinarly slow. Being that + SQLite provides 'EXCEPT' the much faster construct can be used to the same end (at least it was + faster with Oracles's equvalent: 'MINUS', to wit: + + select name,addr from employee where id not in (select id from sales) + + becomes + + select name,addr from employee where id in ( + select id from employee + except + select id from sales + ) + -- Are you calling Oracle 'a bloated piece of software'?. LOL. I would love to see a comparison of Oracle and SQLite (latest stable or bleeding edge SQLite version Vs Oracle 10g). I would love it. [This
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|