Are the queries being run against the same database?
Are the connection pools set up the same on both servers?
Is your test(slower) server located somewhere else geographically?
Maybe just provide us with a bit more data.
On Mon, Apr 27, 2009 at 1:26 PM, Chris O'Connell
Thanks for the response. I finally got the DBA involved and it looks like
the query was executing very slowly on the server. I don't understand
everything that goes on in the communication between the driver and the
database, but it looks like I was seeing those first results coming back
because
Well, let DBA optimize query, but from the iBatis side maybe it makes sense
to increase fetchSize. See e.g.
http://markmail.org/message/3vy7p455yr5qkzbk#query:ibatis%20fetchsize+page:1+mid:tgs7lyqlyetn2jfv+state:results
On Wed, Apr 29, 2009 at 2:01 AM, Chris O'Connell
I know that if I were to get a DBA involved, I could get some further
details, but I'm trying to get as much information as I can before I start
to get the bureaucracy involved...
Anyway, I am able to log my sql and the results with no problems. The issue
I have is that stuff is just running so