4 Replies Latest reply on Jan 26, 2005 5:36 AM by Lothar Egger

    Problem of performance with large tables

    Arnaud Santoni Newbie

      Hi all,

      I'm under jboss3.26
      I've got an entity bean mapped to a table with 33M of records.
      I've done some finders, some are very quick, other very slow...

      for example: (in jbossql)

      select object(o) from TheEntity as o where o.name like ?1 ORDER BY o.name OFFSET ?2 LIMIT ?3

      with a parameter like "toto%" it's really quick
      with a parameter like "%toto%" it's really slow over 10s
      -> it's like if all the results were loads without limit clause

      I tried read ahead strategy but with no significant result

      If someone have an idea....

      Thanks

      Arnaud