I have a SharePoint lists with 10 000 items, and someone else has increased the limit to 250 000 (Crazy right?).
What I have done is I've indexed the Changed By Date, and made views that is sorting by that column.
What I want to know is, when I use CQWP to view the list, it will only view 250 items on 1 page, order by that column. What is going on behind the scene? Does it only query for the newest 250 items, or does it actually get a resultset of 10 000 and order it ?
And question 2. Will something break if I change that limit to 5000, when there is no single query that should return more than 5000 hits?