CMP finder efficiency
Hello. I was just wondering how to implement a component, that fetches information from a database.
I have limited myself to 2 options, either I use a Facade-DAO structure or a Facade-Entity structure. I'm sure you get the picture.
If I go with the DAO approach, I will have to go through JDBC to a database and perform an SQL-query.
The second approach would use a finder method on the entity's home interface.
The application server is BEA WebLogic 8.1. The actual search is pretty easy, only one where-clause relating to a varchar (String) field.
Since there are a lot of experienced guys out there, you propably have something to say on the performance of both of these approaches I just stated.
Will the entity-finder method perform a full table scan to the database every time the finder method is invoked? Is the entity-finder still faster than a regular jdbc-connection?
Thank you for your shared knowledge!
