Skip to Content
0
Former Member
Jul 02, 2009 at 02:50 PM

ICR - Selection times for Customer vs Vendor open items

18 Views

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