Re: SQL Result Paging

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.

--
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.