Question

Workflow Load

Workflow

Updated February 25, 2016

asked on February 24, 2016 • Show version history

Dears,

I need to trigger Laserfiche workflow from a third party application. The third party application can call an XML web service or Jayson only.

1- Please advice if the best solution is to develop another webservice in the middle to call Laserfiche workflow webservice.

The third party system will call the webservice continuously, maybe 4 to 8 times each seconds.

2- is Laserfiche Workflow system can support this kind of Load? such as 500 triggered workflow in 1 minute?

after a workflow is called , the process consists of connecting to another third party database to collect information and send it to a sms gateway.

3- If I want to propose Laserfiche Avante for MSSQL Express edition, I want to know if this obliges me to use SQL Express as back-end db for the workfow or i can use Oracle or MSSQL Standard?

4- Also, can I install Multiple workflow Servers in avante to distribute the load.

Thanks,

Dory

0 0

Replies

replied on February 24, 2016

Workflow is not restricted in terms of what edition of SQL Server it can use. It doesn't matter if you have Laserfiche Avante for SQL Express, you can connect Workflow to a full SQL Server.

For the load you're talking about, I wouldn't try running it with SQL Express because of the performance limitations in SQL Express.

I think you also need to worry about whether the 3rd party data source you're trying to connect is able to handle the load of 500 queries per minute. Even if Workflow throttles the connections (and it most likely will, since it's limited by Windows Workflow Foundation in terms of how many concurrently running workflows it can have), we're still talking about a very high volume of connections to that data source.

Avante allows for unlimited installations of Workflow, so you can distribute the load, though it would be up to your application to decide which Workflow Server to send the call to start a workflow. Though, with this setup, you'd actually be increasing the number of concurrent connections to the data source.

And, completely not a Workflow issue, but does your SMS gateway support that high volume of messages?

0 0

replied on February 25, 2016

not each workflow will send an sms -- each workflow run and check before if the sms should be sent or not.

0 0

You are not allowed to follow up in this post.

Question

Question

Workflow Load

Replies

Sign in to reply to this post.