Hello, Does anybody know the performance overhead induced by the EJB-QL "LOCATE" keyword? Here is my EJB-QL : SELECT DISTINCT OBJECT(c) FROM Constructor AS c WHERE LOCATE(?1,c.name)>0
I'm afraid this code will fetch all the rows in my database table, and then parse them in Java, which will be dog slow. I'm having 10 000 - 100 000 rows in this table, and I'm using commit option A. Anybody with some experience in that field? Or is everybody just using good old DAOs??