Re: SQL Result Paging

Also, just for information. If you had a way to just send out a request as
an XML document and receive the results back as an XML document how would
that work?


On Mon, Mar 11, 2013 at 1:28 PM, Mike Wills <mike@xxxxxxxxxxxx> 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
--
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.