ICR - Selection times for Customer vs Vendor open items

[Former Member]

All/Ralph

We have implemented note 1349849 and tested the selection again. I now have a strange result. The selection of customer open items is fast i.e. 120 000 records in 850 sec, however, the selection of the vendor items takes takes 3600 sec for same volume of items??...and times out.

I have executed several test runs using the selection parameters for both customer and vendor number (just to restrict to one associated company) and the results are consistent, the vendor items take around 3 to 10 times the time as for Customer items.

The respective total data volume in the open item tables was as follows:

BSID - 1.8 mil records

BSIK - 950K records

Has anyone experienced the above scenario?

Regards

Kris

[former_member572578]

Hello Kris,

I suggest you run a trace on the selects and check which indices are used for the tables. You may want to create an additional index for BSIK (or BSAK?) to speed up processing.

Best regards,

Ralph

[Former Member]

Hi Ralph,

We have checked everything again including indexes but still have a massive difference between selection of customers and selection of vendors. I will raise a Service Message as we can't process some of the higher open item volume countries.

Regards

Kris