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
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).