PW 3.0.6: $pages upgrades, link abstraction, more

[ryan]

This week we’ve got some great new optimized methods added to the $pages API variable, plus full link abstraction now built-in, new sub-selector upgrades, and more! 

http://processwire.com/blog/posts/processwire-3.0.6-brings-pages-upgrades-and-link-abstraction/

[renobird]

Thank you Ryan! You are churning out the awesomeness at an astounding rate. Thanks to Antti/Avoine for suggesting the nested sub-selector improvements, I'm looking forward to refactoring a few clunky queries once I can officially move to PW 3. 

[apeisa]

Speed improvements with subselectors are amazing. Our setup went from timeout into pretty much instant when there were about 10 000 pages in both main and sub selectors.

[LostKobrakai]

Speed improvements with subselectors are amazing. Our setup went from timeout into pretty much instant when there were about 10 000 pages in both main and sub selectors.

Came here to ask about a short explanation on what exactly has been done for the "subselector speedup" and now I'm even more curious.

[apeisa]

SQL query changed from joins into using IN and NOT IN syntax.