Well, we've got a good paging system, but I will tell you this: It's been 19 hours since I submitted that query and it's STILL grinding.
And that's with proper indexes, too!