cancel
Showing results for 
Search instead for 
Did you mean: 

slow performance on DI GetByKey function with SBO 8.8

Former Member
0 Kudos

Hi,

Does anyone experience slow performance on DI function GetByKey with SAP B1 8.8 version? I have tested same function to load a Sales Order with 100 lines on B1 8.8 and 2007A version. It takes 7 seconds to load one Sales Order by GetByKey in 8.8 , but in 200A version, these is no delay,

Here is my code.

Dim d1, d2 As Double

Dim ORDR As SAPbobsCOM.Documents

Dim DocNum As Long

DocNum = 29

For ii = 1 To 100

Set ORDR = oCompany.GetBusinessObject(oOrders)

d1 = CDbl(Now)

Result = ORDR.GetByKey(DocNum)

d2 = CDbl(Now)

Debug.Print Result & " , " & ORDR.Lines.Count & " , " & (d2 - d1) * 24 * 3600 & " seconds"

Set ORDR = Nothing

Next ii

RESULT:

2007A:

True , 101 , 0 seconds

True , 101 , 0 seconds

True , 101 , 0 seconds

True , 101 , 0 seconds

True , 101 , 1.00000023376197 seconds

True , 101 , 0 seconds

True , 101 , 0 seconds

True , 101 , 0 seconds

True , 101 , 0 seconds

True , 101 , 1.00000023376197 seconds

Done

8.8 version:

True , 101 , 7.00000037904829 seconds

True , 101 , 6.99999975040555 seconds

True , 101 , 6.99999975040555 seconds

True , 101 , 7.00000037904829 seconds

True , 101 , 6.99999975040555 seconds

True , 101 , 7.99999998416752 seconds

True , 101 , 7.00000037904829 seconds

True , 101 , 6.99999975040555 seconds

True , 101 , 6.99999975040555 seconds

True , 101 , 7.99999998416752 seconds

Done

thanks,

David

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

SAP is going to fix the issue in PL13 for 8.8 version.

=====================================

We would like to inform you that we plan to fix the

problem you raised, in patch 13 for SAP Business

One 8.8.

Please look for note number: 1467853 in the Service

Marketplace to verify that the suggested fix we will

perform is aligned with your expectations.

The next update of this message will inform you of the

delivery plan.

Former Member
0 Kudos

David,

we happened this issue when we were replaced the DI API version in our project from 2007 to 8.8. After replacing the DI API to 8.8 and compiling the addon the issue solved.

Did you tried?

Regards

J