On 10/14/2014 3:51 AM, Mark Lawrence wrote:
On Tue Oct 14, 2014 at 09:25:20AM +0200, RSmith wrote:
To get even more compact, I would go with Igor's SQL which ... will run quite a
bit slower
I'm a little curious about why you say a CTE statement is slower than a
VIEW for large tables.
My query uses neither views nor CTE. I'm a little curious about how a
comment on the former could be construed to reflect in any way on the
latter.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users