uPortal-Project/NewsReaderPortlet

Add index to SET_ID column in NEWS_CONFIGURATION

Closed this issue · 1 comments

bjagg commented

Report from TAMU that with Oracle db, index on SET_ID is not created. This causes performance issues.

bjagg commented

NewsConfiguration.hbm.xml

        <many-to-one 
            name="newsSet" 
            class="org.jasig.portlet.newsreader.NewsSet"
            cascade="merge, persist, refresh" lazy="false">
            <column name="SET_ID" index="SET_ID_IDX" />
        </many-to-one>