I have a query that is sub-second. When I run it on the green-screen, I get
a result as soon as I hit "enter". So I know that that query itself isn't
the problem. I am returning around 800 results.
However, when I pipe it through my C# ASP.NET application, it takes FOREVER
(okay 3 minutes), but lets be honest, that is forever in the web world.
My question is, how do I go about adding paging to my query. I found this
400 Guru article (http://www.itjungle.com/fhg/fhg111109-story01.html), but
was wondering if there were other ways. Maybe using a stored procedure or