Performance Testing

[Former Member]

Hai To All,

Using Test Environment we can able to test our addon in SAP B1 is ok. But if i insert more than 50000 records what could be the result of performance of Addon???

How to do that in SAP B1 ???

Does anyone have idea about this??????

Regards,

Anitha

[Former Member]

Hi Anitha,

To test the performance of an SDK Add-On inserting records you can create a small test project and run it on a Demo database, timing how long it took to add the items:

Private Sub insertBP()
        Dim oBP As SAPbobsCOM.BusinessPartners
        oBP = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oBusinessPartners)
        Dim i As Integer

        Console.WriteLine("Start Time" + DateTime.Now)

        For i = 0 To 10
            oBP.CardCode = "Test" + i.ToString
            oBP.CardName = "Test" + i.ToString

            oReturn = oBP.Add

            If oReturn <> 0 Then
                oCompany.GetLastError(oError, errMsg)
                MsgBox(errMsg)
            End If
        Next

        Console.WriteLine("End Time" + DateTime.Now)
    End Sub

My loop adds 10 Business Partners but you can expand this out to a larger number to get a better idea of the performance for large amounts of data.

Hope this is useful to you,

Regards

Niall

SAP Business One Forums Team

[Former Member]

Thanks for ur reply.....

But i want to be tested by addon perfectly....Is there any tool to do this type of testing????

Regards,

Anitha

[YatseaLi]

Hello ani,

Did you try .Net Profiler in B1TE tool set? With .Net Profiler you can know what DI and UI , even any .net fuction has been call and its time consumption. But note that your addon should be built on top of .Net. Are you going to create some performance benchmark for you addon? Thanks.

Kind Regards

-Yatsea

[Former Member]

Hi Anitha,

The SAP Business One Test Environment Tools contain some useful tools for this type of testing. For example the .NET profiler which logs each call made to the DI API and how long the call took to complete. In the 2007 version this tool set also gives you access to the xml log files produced by the DI API which allows you to analyze all DI API calls with detailed information like interface and command name, elapsed time, input and output types and values.

These tools are available by going to the following link and clicking "Business One SDK tools" under the "Downloads" section on the right of the page:

[]

Currently this is the only tool set I am aware of for testing Business One add-ons.

Regards,

Niall

SAP Business One Forums Team