We are adding a Java app (JBoss, Linux) to the existing 4GL (9.1D, custom web interface) app. I have done everything I can find to help (second broker, "update statistics", cut server load), but while the 4GL app runs OK, the SQL is very slow.
Some of this is SQL. (Progress handles "where A...