Executing Queries with maximum row counts

[Former Member]

Dear Community,

I have a question regarding Queries in ABSL. I want to use the execute function with the maximum rows and start rows in order to get a better performance while executing queries.

An example to query BusinessPartners:

var query = BusinessPartner.QueryByIdentification;

var selPara = query.CreateSelectionParams();

var contacts = query.Execute(selPara, dummy , maxRowCount, start);

The second Param (dummy) should be the SortingParameters, but there are no sorting Parameters available for the BusinessPartner BO.

Do you have any suggestions to use the maximum row count to execute queries on the BusinessPartner BO?

Kind Regards,

Lukas

[umehring4cloud]

Hi Lukas,

I am afraid that this won't work for Business Partner BO. Nevertheless you can use ExecuteDataOnly() if you don't want to change the BO. This is faster than the normal Execute().

If you explain what you want to do, someone might be able to find some work-around. Btw. the subspace is a better place for development related questions and gets you a better chance of getting this question answered.

Best regards,

Uwe

[Former Member]

Hello Uwe,

I know the handling with the ExecuteDataOnly() function and I have already a workaround, but the handling with the max-row parameter would be a nice option.

Kind Regards,

Lukas