1 Reply Latest reply on Sep 3, 2002 11:15 AM by dsundstrom

    endless ORs in generated SQL querries

    mmenz

      Hello,
      looking at the logs of jboss 3.0.1 running with a informix datatbase I found the following statement:
      SELECT nr,msgNr, art, text FROM message WHERE (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?) OR (nr=?)

      It doesn't lead to any errors but I think it will definitely cost performance. Any ideas what or where I forgot to configure?? Thanks in advance

      Matt

        • 1. Re: endless ORs in generated SQL querries
          dsundstrom

          This is optimized loading (block loading), and improves preformane by avoiding 'endless' select statements that select one row at a time. Configuration of optimized loading is covered in the JBossCMP documentation available from flash line ($10).