On 2/15/17, Simon Slavin <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
