0 Replies Latest reply on Jul 25, 2003 9:33 AM by Julien Dubois

    Performance of the EJB-QL "LOCATE" keyword

    Julien Dubois Newbie

      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.