- If you are receiving a lot of result try setting the result fetch size to a large number.
- Consider consolidating queries - Consider executing queries from a stored procedure - Consider pre-fetching some of the information before the time you actually use it - Consider using application level caching.
Alternatively, can you fold these queries down using database joins? The overhead for setting up a query can be substantial, especially if you're not using prepared statements (although CMP EJBs normally would).
Customer surveys are for companies who didn't pay proper attention to begin with.