Skip to Main Content

Application Development Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get cm:search to use the max attribute when creating the SQL query?

657507Oct 3 2008 — edited Oct 3 2008
When we use the max attribute in the cm:search tag, it does not seem to honor the max attribute when creating the SQL query. However, the result returned from the tag is limited to the number specified by the max attribute. Then the tag seems to work as intended, but the performance will be sub optimal when the SQL query returns unnecessary rows to the application.

We use the cm:search tag to list the latest news (ordered by date), and with the current implementation we have to expect a decrease in performance over time as more news is published. But we can’t live with that. We need to do the constraint in the SQL query, not in the application.

The sortBy attribute of cm:search is translated to “order by” in the SQL query, as expected.

Is it possible to get cm:search to generate the SQL query with an addition of “where rownum <= maxRows”?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 31 2008
Added on Oct 3 2008
1 comment
359 views