[sqlite] cross join very slow, which is better select virtually using cross join, or create physically data output from cross join?

Hi All, I tried to create Cartesian list from 8 digit text that has 256 row. when I try below statement, the time to fetch the result was very long, I'm always press ctrl+c because its run more than 20 minute: select a.a,b.b,c.c,d.d, max(length(a.a||b.b||c.c||d.d)) as e from (select text8) as a

Re: [sqlite] cross join very slow, which is better select virtually using cross join, or create physically data output from cross join?

iip iip.umar.ri...@gmail.com wrote: I tried to create Cartesian list from 8 digit text that has 256 row. when I try below statement, the time to fetch the result was very long, I'm always press ctrl+c because its run more than 20 minute: select a.a,b.b,c.c,d.d,

Re: [sqlite] cross join very slow, which is better select virtually using cross join, or create physically data output from cross join?

On Sun, Jun 12, 2011 at 8:58 PM, Igor Tandetnik itandet...@mvps.org wrote: iip iip.umar.ri...@gmail.com wrote: I tried to create Cartesian list from 8 digit text that has 256 row. when I try below statement, the time to fetch the result was very long, I'm always press ctrl+c because its