RE: SQL Result Paging

Nothing too peculiar there.

Are you 100% sure that this line:

using (iDB2DataAdapter da = new iDB2DataAdapter(cmd)) { da.Fill(dt); }

Is causing the 3 minute delay? Did you test it through the debugger?

Reason I ask is this line: "The speed issue in here as calling the directly from Poster in Firefox takes 3 minutes.".

This would seem to indicate to me that perhaps it is taking Firefox 3 minutes to parse the massive amount of data you are sending back, over a 56K modem line :-)

-----Original Message-----
From: Mike Wills [mailto:mike@xxxxxxxxxxxx]
Sent: Monday, March 11, 2013 3:05 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQL Result Paging

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.

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