- 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).
An IDE is no substitute for an Intelligent Developer.