Your problem is that there is no index on the range-fields, itemId
and transType.
You can create a new index on the InventTrans table containing these
two fields to test if this fixes the performance problem.
Best regards,
thy:development
Karsten Wollesen Clausen
--- In [email protected], "Cenk Ince" <[EMAIL PROTECTED]>
wrote:
> Hi all;
>
> I have a query in a lookup method. It is below. It looks to me
work slowly. I added index below but it doesn't make to much
performance increase.
>
> How can i amke it run quicklier?
>
> Thanks...
>
> Query query = new Query();
> QueryBuildDataSource queryBuildDataSource;
> QueryBuildRange queryBuildRange;
> SysTableLookup sysTableLookup =
SysTableLookup::newParameters(tableNum(inventTrans), _formcontrol);
> ;
> sysTableLookup.addLookupField(fieldNum(inventTrans,
inventTransid));
> sysTableLookup.addLookupField(fieldNum(inventTrans,
Transtype));
> sysTableLookup.addLookupField(fieldNum(inventTrans,
TransRefid));
> sysTableLookup.addLookupField(fieldNum(inventTrans, itemid));
> sysTableLookup.addLookupField(fieldNum(inventTrans, Qty));
> queryBuildDataSource = query.addDataSource(tableNum
(inventtrans));
> queryBuildDataSource.addRange(fieldNum(inventTrans,
itemid)).value(CNK_IthalatSatir.urunKodu);
> queryBuildDataSource.addRange(fieldNum(inventTrans,
TransType)).value(enum2str(inventTransType::Purch));
> queryBuildDataSource.addSortIndex(indexnum(inventtrans,
itemidx));
> sysTableLookup.parmQuery(query);
> sysTableLookup.performFormLookup();
>
>
>
> [Non-text portions of this message have been removed]
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
