Query that sorts a large result set.

[Ian Boston]

Hi,

I want to perform a query where the full result set could be millions  
of items. That set needs to be sorted by the lastModified attribute on  
the node, and I only want to see a small number of items eg 100 after  
a particular date.

If I do this, will there be scalability issues, or is the sorting of a  
date field optimized in the query engine ?

Thanks
Ian