-
1. Re: Need to optimize
adrian.brock Jan 31, 2003 11:36 AM (in response to chadlavy)<jbosscmp-jdbc>
<page-size>100</page-size>
To limit the read-ahead, the default is 1000.
Regards,
Adrian -
2. Re: Need to optimize
chadlavy Jan 31, 2003 1:33 PM (in response to chadlavy)I made the change you described in my jbosscmp-jdbc.xml as follows:
java:/MDRDBP01
<datasource-mapping>DB2</datasource-mapping>
<create-table>false</create-table>
<remove-table>false</remove-table>
<read-only>false</read-only>
<pk-constraint>true</pk-constraint>
<fk-constraint>true</fk-constraint>
<page-size>100</page-size>
It did not seem to help...
Is there a way that I could override the sql using JBossQL or something like it in this file? I've seen people mention that the documentation for this is in the 'FULL DOCUMENTATION'. We purchased the electronic version of the JBoss Book 3.x and don't see any mention of JBossQL or the dynamic sql functionality that can be used in this file.