Josh,
Thank you for your input!

The problem is "knowing in advance" how many records I'll get.

"If you really need to process 1M records, it's just going to take a while."
This is a great philosphy, in my opinion - I try to tell users this all the time! Can I quote you on this, to help back me up? Just kidding!! (:D)

Thanks again!
Mark

>A query that returns a lot of records will take a while. Most of the time is probably spent actually creating the resulting cursor. If you know in advance that you're going to get almost all the records you might want to just set relations and filters or just set relations and filter the records as you go.
>
>You should try to make your queries return as few records as possible (of course). If you really need to process 1M records, it's just going to take a while.