[wp-hackers] Seeking SQL advice to identify performance problem

[Simon Blackbourn]

>
>
> > 'number'     => 1000000, //  unfortunately you can't use -1 here
>
> Actually, unlike WP_Query, users are not paginated by default, so if you
> don't pass the 'number' parameter at all, you'll get all the users.
>
>

Sorry, yes you're right.

By the way, I just thought I'd say that this thread for me demonstrates a
perfect example of what as a developer I love about the direction WordPress
has taken: classes such as WP_User and associated functions like get_users
remove the need (in 99% of cases) to faff around with SQL, provide a
massive level of flexibility through the parameters array, and with things
like the meta_query parameter we have very similar syntax whether working
with posts, pages, attachments, users or whatever. Kudos to the people who
put all the thought & foresight into these kind of things.