Import Sales Order or Invoices using DI API

[Humberto_Neira]

Hi all,

I have the requeriments over Imports over 200 sales order in the same time and mi questions is , what is the performnace of B1 or SDK in this import process?

Someone have a best practices for implement this functionality?

Someone have a documentation over performance test for this import process?

regards

[Humberto_Neira · Accepted solution]

The case is:

Enviroment WEB with the application to receive sales order (aprox 200 concurrents transactions) and we need to know:

What must be the best solutions?

I have my opinion:

-. Use DI Server to comunicate environment Web (external) with environment B1 (internal)

But , i need know what is the performance of DI server or DI API in this situation.

regards

[Former Member · Accepted solution]

slow, we have seen it standardly run ~2000 transactions / hr

max of ~4000 transactions / hr with big server and optimized database. really will vary depending on the number of business partners and items you have.

if you are doing 200 <b>concurrent</b> transactions are you sure Business One is the right product for you, that sounds pretty enterprise level to me.

hopefully this will improve in Business One 2005

[Former Member · Accepted solution]

Well, what about your web interface writing to a seperate table, the DBDatasource object is quite quick from what I have seen, have not pushed it nealy to that volume, but my 15-30 records I do at a time seems to work just fine, let your web app write to a separate db, and then use the dbdatasource to read from it, and com objects to process it.

I also agree with Shawn, SQL might handle that volume, but b1 might not be up for the task.

Regards

[Former Member]

Hi Humberto,

I would suggjest that you take a close look at the documentation that came with DTW(Data Transfer Workbench)

Or if you need to do it via code, what is the reason for it so that I may better understand, and I will gladly assist you with some code samples.

Leonard