I'm thinking something else is going on with your application or you are running the query through a 10MB half-duplex Ethernet line :-)
We return thousands of rows in 1-2 seconds time, 800 rows should be under a second in our environment using C# ASP .NET app.
Paste the code to the midrange .NET mailing list - systemidotnet@xxxxxxxxxxxx.
-----Original Message-----
From: Mike Wills [mailto:mike@xxxxxxxxxxxx]
Sent: Monday, March 11, 2013 2:29 PM
To: midrange-l@xxxxxxxxxxxx
Subject: SQL Result Paging
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
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
