разная скорость отработки display методов на источнике данных формы

[wojzeh]

\Forms\DynLinkCustTransForm\Designs\Design\[Group:Group]\[Group:Group2]\RealEdit:getTotalAmountCurByCustTable (DS: CustTable)
\Forms\DynLinkCustTransForm\Data Sources\CustTable\Methods\getTotalAmountCurByCustTable
------------------------------------------------------------------------------------------------------------------------------------------------

display AmountCurDebCred getTotalAmountCurByCustTable(CustTable _CustTable)
{
    ;
    select sum(AmountCur) from ctr
        where ctr.AccountNum == _CustTable.AccountNum;

    return ctr.AmountCur;
}

\Forms\DynLinkCustTransForm\Designs\Design\[Group:Group]\[Group:Group2]\RealEdit:getTotalAmountCurByCustTrans (DS: CustTrans)
\Forms\DynLinkCustTransForm\Data Sources\CustTrans\Methods\getTotalAmountCurByCustTrans
------------------------------------------------------------------------------------------------------------------------------------------------

display AmountCurDebCred getTotalAmountCurByCustTrans(CustTrans _CustTrans)
{
    ;
    select sum(AmountCur) from ctr
        where ctr.AccountNum == _CustTrans.AccountNum;

    return ctr.AmountCur;
}

\Forms\DynLinkCustTransForm\Designs\Design\[Group:Group]\[Group:Group2]\RealEdit:getTotalAmountCurByCustTable1 (DS: CustTrans)
\Forms\DynLinkCustTransForm\Data Sources\CustTrans\Methods\getTotalAmountCurByCustTable
----------------------------------------------------------------------------------------------------------------------------------------------

display AmountCurDebCred getTotalAmountCurByCustTable()
{
    ;
    select sum(AmountCur) from ctr
        where ctr.AccountNum == CustTable.AccountNum;

    return ctr.AmountCur;
}

\Forms\DynLinkCustTransForm\Designs\Design\[Group:Group]\[Group:Group2]\RealEdit:totalAmountCur (DS: CustTable)
\Data Dictionary\Tables\CustTable\Methods\totalAmountCur
--------------------------------------------------------------------------------------

display AmountCur totalAmountCur()
{
    CustTrans  custTrans;
    ;
    select sum (AmountCur) from custTrans
    where custTrans.AccountNum == this.accountnum;

    return custTrans.AmountCur;

}

табличный метод вызывался сначала без кеширования, затем с кешированием. вот результаты профайлинга: