You are viewing limited content. For full access, please sign in.

Question

Question

How can I improve the performance of Cloud Rules on tables with a few hundred rows

Rules Laserfiche Cloud
Updated May 5
asked on April 23

My table has 383 rows.

This rule clears like 5-10 rows of data from a very basic table and takes 27 seconds.

This rule inserts a single row into a table and takes 30 seconds on average across 3 runs

The goal is to proceed from one task assignment to another with a workflow that makes a few simple updates to the tables, and using the following feature of BP tasks before the timeout.

There has got to be a way to get better performance updating very small quantities of data in a table.

0 0

Replies

replied on April 23

Is this rule for a Lookup Table or an external table?

 

0 0
replied on April 23

A lookup table. External tables in SQL can do this in milliseconds

0 0
replied on April 23

Could it just be intermittent?

I believe I have pushed the bounds of lookup tables both from a rule and from the api and I have never seen that kind of slow performance. Both of those ops should be sub 2 seconds.

0 0
View 1 previous reply
replied on April 23 • Show version history

Sub 2 seconds is like 15x faster, that is a huge gap. It does go faster sometimes, but I want to optimize it so that it is always fast. It should be possible to have consistent 2 second performance with around 300 rows and 6 columns, even with low to moderate compute. The data is very small and a CPU can crunch this stuff with ease.

0 0
replied on May 5 • Show version history

It is actually just getting worse and worse over time. Each day getting slower even as I work with less and less rows. This one for example was removing 2 rows from a table of 300 rows total.

I need a better solution than rules for working with Cloud tables.

The Tables API is much faster but I am not sure how to call it from a Business Process without hosting another listener on my own server.

This one is still running and retrieves 1 row of information from a table with 100 rows.

0 0
replied on May 5

Do you have a Business Process calling a Workflow which contains the Rules?

I had a similar experience of intermittently slow Workflow execution.

Ended up putting rules inside the Business Process Flow Diagram so they run without needing a Workflow

0 0
replied on May 5

I have both, but I have experienced worse performance calling the rules directly. For example I have a decision table with just 4 columns and 4 rows and it times out all the time before finishing executing with a direct call from business processes.

Calling a workflow at least allows me to wait for it to finish with no timeout so that I can ensure the rules actually run as well as add logical operations.

The rules system itself just can not handle more than a couple rows, so for working with real data I need a new approach to be able to query and work with the data besides rules. The API is the only thing I can think of and maybe I need to call it from WF.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...