0 Replies Latest reply on Aug 4, 2004 2:48 AM by nikita tovstoles

    does using stored procedures mean no CMP? also, what happens

    nikita tovstoles Newbie

      Hi,

      I recently read http://j2eeadvisor.com/doc/14180 that sometimes it is beneficial (performance-wise) to use stored procedures for more complex queries (i guess instead of entity finder methods). but does using stored procedures force one to abandon CMP, and use BMP?

      on that note, what does an AS do with EJQL queries? Are they:
      -translated into SQL which is then executed by RDBMS
      -executed by the AS itself (thereby possibly resulting in multiple queries to RDBMS
      -other?

      thanks a lot
      -nikita
      [/url]