cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in Performance of Add-on

Former Member
0 Kudos
61

Hi all,

I have made a program for Payroll in Vb.net where i need to upload the attendance of 5000 employees through an excel sheet.

That is, 5000 employees * 30 days so there will be a line item of 150000 in the excel sheet.

My issue here is,

It takes very long time to get upload into my system, the performance of my add-on is very worst.

How to resolve this issue???

Help me solving this issue friends.

Regards,

Janani

Accepted Solutions (0)

Answers (3)

Answers (3)

edy_simon
Active Contributor
0 Kudos

Hi,

1. Upload to a UDT or UDO ?

2. Are you uploading only or you process the record and post some documents in SAP.

3. How do you read the excel file ? via Excel automation or via .NET recordset ?

Regards

Edy

Former Member
0 Kudos

Hi Edy,

1)I am uploading the data to a UDT

2)I don't understand what exactly you are trying to say Edy.

3)Through .NET recordset

Regards,

Janani

Former Member
0 Kudos

Hi Edy,

2) I upload that excel sheet and place the values in a no object table and from that table i retrieve all the data use in the add-on

Regards,

Janani

edy_simon
Active Contributor
0 Kudos

Hi Jana,

Since it is a no object UDT, are you uploading through DI User Table object ?

or via Recordset sql insert statement ?

And for your case, how long does it take to upload the whole 150k of records ?

Regard
Edy

former_member445524
Participant
0 Kudos

If you are loading the Excel file "through .NET recordset", as you say, then whatever performance problem you have it has nothing to do with SAP Business One, because your loading code does use B1 SDK. Try determining the exact location of the bottleneck, be it the reading from Excel, some intermediate processing, or the loading into the DB, and ask a more specific question in a more suitable forum, like MSDN (for Excel and DB, if it is MS SQL)...

Former Member
0 Kudos

Hi Edy,

I am using the user table to upload the data.

In my case , it takes about 10 mins for uploading 1500 records.

Help me solving this issue.

Regards,

Janani

edy_simon
Active Contributor
0 Kudos

Hi Jana,

The summary :

1. Reading Excel using ADO Recordset.

2. Uploading into a UDT - No Object using UserTable object.

3. 1500 records = 10 minutes.

Can you try to use DI Recordset to upload this data ?

My case, I uploaded 12000 records in less than 1 minute,

Regards
Edy

Former Member
0 Kudos

Hi janani..

There is no options.

System will behave like this only..

5000 employees * 30 days


Reduce the  No of emplyees *30

this is one option..(I am don't think this is the correct answer)


One more option is there....These are good

DI Server or B1if

but i dont have any experience.





maik_delly
Active Contributor
0 Kudos

Hi Janani,

I guess you are using DI API to write the data to an UDT ?

If so it really needs a lot of time. For this scenario DI Server or B1if are preferred.

Especially DI Server is disigned for heavy duty operations - but don't expect miracles, it is still time consuming.

If your UDT is from type non-object you could also use SQL to insert the data - as far as I know SAP support is not breached and this is by far the fastest solution ( of course your insert logic must be flawless, since resulting problems are not supported) .

regards,

Maik