Hi -
Sybase ASE has a limitation of 250 ANDs/ORs in a select. It also has a
limitation of 250 elements inside of an IN. We've encountered a problem
with the way that JBoss CMP pulls large sets of data from the database
because of this limitation. CMP engine first pulls all of the primary keys
Hello Robert,
have tried tuning read-ahead?
alex
Tuesday, December 10, 2002, 9:32:01 PM, you wrote:
RM> Hi -
RM> Sybase ASE has a limitation of 250 ANDs/ORs in a select. It also has a
RM> limitation of 250 elements inside of an IN. We've encountered a problem
RM> with the way that JBoss CMP