Query Optimization

[jaybuddy]

Hello!

This isn't so much an issue as just something to think about...

For sites that have lots of posts (say over 3 million) sitemap generation get increasing slow. From what I can tell its from the LIMIT usage with an offset in the query. I was looking into a way to modify the query to remove the offset in the LIMIT clause and keep track of your place in the posts via the where clause as you cycle.

ex. WHERE ... p.ID > last post id from previous cycle...

I've been looking through the source code and it seems like that is going to be a fairly difficult optimization to make. Do you have any suggestions?