On 2/15/17, Simon Slavin <slav...@bigfraud.org> wrote: > select * from albums, album_asset, cacheReferences, coreInfo, space limit 1; > > It’s using 100% CPU time (on a multicore CPU).
It is still a 5-way join. It will terminate after looking at all 20,318,172,864 possible combinations of albums, album_assets, cacheReferences, and coreInfo and realizing that the space table will be empty in every case. It is an optimization opportunity, not a bug. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users