I still consider it a work around for adhoc queries. Programatically I can
of course use it easily, but when analysing data one runs many adhoc queires
which you change minute on minute. Having to create temp tables for each
change and give it a new name for each change is a real pain.
Further
On 12/2/08, Da Martian <[EMAIL PROTECTED]> wrote:
> Hi
>
> I have continious issues with subquery performance when subqueries are used
> for joins. It crops up all the time my daily work.
>
> If you create a derived table using a subquery and use it in a join SQLite
> performance is abysmal.
Hi
I have continious issues with subquery performance when subqueries are used
for joins. It crops up all the time my daily work.
If you create a derived table using a subquery and use it in a join SQLite
performance is abysmal. However if you make a temp table from said subquery
and index this
3 matches
Mail list logo