800 is not too much for a web page, it should display fast enough, but
unlike the grenn screen, after you send the page, all forward, search,
etc- is done in the browser, very fast.
Try sending the page to the browser using CGIDEV. If it is faster, you
can "mix" it in your query.
Mike Wills wrote:
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
something?
--
Mike Wills
http://mikewills.me
