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??
Julien Dubois.