Re: SQL Result Paging

[Mike Wills <mike@xxxxxxxxxxxx>]

The relavant code is posted at
https://gist.github.com/MikeWills/528dac8511b9295cdb16

--
Mike Wills
http://mikewills.me


On Mon, Mar 11, 2013 at 2:57 PM, Matt Olson <Matt.Olson@xxxxxxxx> wrote:

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