Re: connection pool.. got it figured...

How many calls to getConnection() are you making during the run? In other
words, how many Connection objects are you using?
Is this under the first request to get the report or under multiple
requests/multiple clients?
What are you setting maxConnections while constructing the Connection pool?

PS: If the DB is Access, not sure if connection pools help, since I am not
sure if the same Access db can be concurrently accessed by multiple clients,
with any degree of scaling.

Bharath.

----- Original Message -----
From: "Brad Stone" <brad@bvstools.com>
To: <java400-l@midrange.com>
Sent: Wednesday, January 09, 2002 6:55 PM
Subject: Re: connection pool.. got it figured...


> I should probably also state the results.
>
> The speed was 10000000 times faster, for the first 100 or so
> records.. after that, it slowed to 1 every 2 or 3 seconds.
> Not sure why that is.
>
> I debugged my connections and at any given time there is
> only one open, which is what I wanted.  So there must be a
> problem somewhere else in my application... hmm..
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>