This post originated from an RSS feed registered with Ruby Buzz
by Matt Williams.
Original Post: JBoss and Sesame Street's Count
Feed Title: Ramblings
Feed URL: http://feeds.feedburner.com/matthewkwilliams
Feed Description: Musings of Matt Williams
One, One database record!
Two, Two database record!
Muahahaha!
By default, when using datasources with JBoss, it does a count to validate a connection, both on creation and when it is requested from the connection pool. It looks something like:
select count(*) from x
Now, this can take take a while when working with tables containing 1.8 million rows and [...]