Huge number of excluded IDs in get_pages dramatically slows down the site

[mikelopez]

Hi,

Just noticed that my site slows down dramatically if a huge number of IDs are passed for exclusion to get_pages.

Site slow down are tracked down to a foreach loop and a mysql query that uses multiple AND ID <> xx instead of ID NOT IN () which is better for performance.

Attached is a patch to fix improve this part of the code and also speeds up the site.

Thanks for considering my first contribution.

Mike

[SergeyBiryukov]

Duplicate of #22074.

[mikelopez]

Patch file

[mikelopez]

Just worth noting that even if the resulting query is still long, it's a lot faster.