• dataView is terrible slow

    By Ulrich Krause 1 decade ago

    I have the new version of the ExtLib installed and added the property infiniteScroll to the dataView Control.
    The application became terrible slow in all areas. The preƶ
    load took forever, adn so did the transition back from an opened document to the page containing the dataView Control.

    Here is my code.
    The data is stared in a seperate application. The view is a simple view. First column is categorized and contains the creation date of the document
    All other columns contain simple text


    <xp:view xmlns:xp=“http://www.ibm.com/xsp/core” xmlns:xe=“http://www.ibm.com/xsp/coreex”

    xmlns:xc="http://www.ibm.com/xsp/custom">
    <xp:this.dataContexts>
        <xp:dataContext var="DataViewId" value="${compositeData.DataView.ID}"/>
    </xp:this.dataContexts>
    <xe:dataView id="${DataViewId}"
        rows="${compositeData.DataView.Rows}"
        pageName="${compositeData.DataView.OpenPage}"
        openDocAsReadonly="${compositeData.DataView.OpenReadonly"
        var="viewEntry" collapsibleRows="true" collapsibleDetail="true"
        columnTitles="true" disableHideRow="true" showCheckbox="true"
        infiniteScroll="enable">
        <xe:this.categoryColumn>
            <xe:viewCategoryColumn
                columnName="${compositeData.CategoryColumn.ViewColumn}"
                columnTitle="${compositeData.CategoryColumn.Title}"
                contentType="${compositeData.CategoryColumn.ContentType}">
                <xe:this.converter>
                    <xp:convertDateTime locale="${context.locale}"/>
                </xe:this.converter>
            </xe:viewCategoryColumn>
        </xe:this.categoryColumn>
        <xe:this.extraColumns>
            <xe:viewExtraColumn columnName="Subject" contentType="text"
                style="font-size:8pt;font-style:italic"/>
        </xe:this.extraColumns>
        <xe:this.iconColumn>
            <xe:viewIconColumn>
                <xe:this.icons>
                    <xe:iconEntry>
                        <xp:this.url><![CDATA[#{javascript:
    

    if(viewEntry.getRead(userBean.canonicalName) ){
    return “xpPostRead.png”;
    }else {
    return “xpPostUnread.png”;
    }
    }]]>

                    </xe:iconEntry>
                </xe:this.icons>
            </xe:viewIconColumn>
        </xe:this.iconColumn>
        <xp:this.facets>
            <xp:link escape="true" text="More Documents"
                xp:key="pagerBottom" loaded="${compositeData.DataView.MoreButton}"
                id="${lnk.DataViewId}">
                <xp:eventHandler event="onclick" submit="false">
                    <xp:this.script>
                        <xe:addRows rowCount="10"
                            disableId="${lnk.DataViewId}" for="${DataViewId}" state="true"/>
                    </xp:this.script>
                </xp:eventHandler>
            </xp:link>
        </xp:this.facets>
        <xe:this.data>
            <xp:dominoView var="view1" databaseName="bccmp\mp_qdb.nsf"
                viewName="QuarantinedMails\ByDate" sortColumn="$21"
                sortOrder="descending"/>
        </xe:this.data>
        <xe:this.summaryColumn>
            <xe:viewSummaryColumn columnName="From"/>
        </xe:this.summaryColumn>
    </xe:dataView>
    <xe:pagerSaveState id="${state.DataViewId}" for="${DataViewId}"
        globalRows="true"/>
    

    • By Martin Donnelly 1 decade ago

      Hi Ulrich,
      You say that the “application became terrible slow in all areas” once you installed the latest ExtLib from OpenNTF.org and turned on infinite scroll. Prior to this, what were your running with ? 9.0.1 Gold and another version of the 901 ExtLib? Also, did you try turning infinite scroll off again and just use a pager? Find it hard to conceive why infinite scroll would cause your app to slow down as it's not doing much different to the pager in terms of the code it calls.
      Also you mention that the db is in a different NSF - is this on a different server, and again, has this part changed from before? Trying to narrow down the problem as we have not been seeing performance issues in this area. –Martin

      • By Ulrich Krause 1 decade ago

        I had 9.0.1 GOLD installed w./o. any additional extLib
        I then installed (via Updatesite OSGI ) the latest version of the extlib and restarted the server.
        Did the same on the client to have the latest features available.
        I then activated infiniteScroll. No other changes to the source code
        The data is in another DB on the same server. Also here , no changes.

      • By Ulrich Krause 1 decade ago

        I used a pager prior to using the “more Documents” button.
        have not tried the pager with the latest extLib.