Question

FORMS calculations

Forms

Updated November 22, 2016

asked on May 25, 2016

Hi all,

Has anybody had any experience where the calculations in a table starts to perform slower the more rows you start adding?

My 1st row takes 1-2 seconds to load lookup data and perform calculations.

After clicking Add Row, for the 2nd row, it takes 2 seconds before it appears and 5 seconds after selecting a drop down menu item before any calculations occur.

After clicking Add Row, for the 3rd row, it takes 5 seconds before it appears and 10 seconds after selecting a drop down menu item before any calculations occur.

It gets progressively worse the more rows you add. By the 5th row you have to wait at least 30 seconds before the row even appears.

My data selection is not that large and all other data lookups are almost instant.

Any suggestions?

Thanks

Ian

The more

0 0

Answer

SELECTED ANSWER

replied on August 17, 2016

The issue has been fixed in Forms 10.1 update 2 (10.1.0.619), you can download the update from https://support.laserfiche.com/kb/1013792

0 0

View 5 previous replies

replied on August 17, 2016

Good day,

The update has definitely improved the performance.

Thanks

Ian

0 0

replied on September 21, 2016

Good day,

While the improvement is noticeable, the slowness returns after + - 12 lines entered on the table.

Regards

Ian

0 0

replied on September 21, 2016

You mean it is slow if you click add to add 12 rows or click delete to remove 12 rows?

0 0

replied on September 22, 2016

Good day,

The performance slows down the more rows you add so by the time you reach the 12th row, the form becomes unmanageable and the browser shows No Response.

It takes + - 1 min before the row is even displayed after clicking Add Row and the after selecting a drop down menu item a further 1 min before the value is displayed.

0 0

replied on September 22, 2016 • Show version history

We tested adding more than 30 rows before, the performance is acceptable. Can you open an support case by providing your exported process and video for reproduce the issue?

0 0

replied on September 22, 2016

Thank you, ticket logged

0 0

replied on November 21, 2016

Good day all,

The new update 3 has solved this issue.

Thank you Xiuhong for assisting.

0 0

replied on November 22, 2016

Thanks for letting us know.

0 0

Replies

replied on May 25, 2016

Have you tested it with another Browser. if there is a difference then it is definitely a memory issue. If it is same then it is SQL response time issue. As we know SQL gets slower and slower as there are more joins involved but i am not sure if there are any in your case. Then you could look into SQL optimization. Maybe better optimized stored procedure.

What sort of calculations are you perfomring on each row?

0 0

replied on May 26, 2016

Hi Junaid,

Yes I have. Same result.

I am performing about 7 calculations across the row. Most basic arithmetic. I have removed most of the formulas now and the speed improves. As I add them back one at a time it reduces. It seems to be the INDEX part of the formulas. The more I use this the slower it gets.

Let me try replacing some of them with javascripting to see if that helps

0 0

View 4 previous replies

replied on May 26, 2016

Hi Ian, can you share with us what your table looks like and what calculation you are using? We can test the performance and see whether it can be improved.

0 0

replied on May 26, 2016

Hi Xiuhong,

I have reduced my table for testing purposes and this has reduced the delay, nonetheless the problem still occurs.

My table is as follows -

Item Code - Drop down filled from a SQL lookup of + - 400 items

Import Cost- Lookup from SQL match on Item Code

Landed Cost - Import Cost x Exchange Rate (entered out of table) x landed ratio (entered out of table) =PRODUCT(INDEX(Table.Import_Cost,ROW()),Exchange_Rate,1+Landed_Cost_Factor)

Selling Price - Lookup from SQL match on Item Code

Margin Value - Selling Price - Import Cost =(INDEX(Table.Selling_Price,ROW())-INDEX(Table.Landed_Cost,ROW()))

Margin % - Margin Value / Selling Price =(INDEX(Table.KDZA_Margin_Before_Value,ROW())/INDEX(Table.Selling_Price,ROW()))*100

By the 5th or 6th additional row you start to notice the performance issue.

Thanks

Ian

0 0

replied on May 26, 2016

Hi Ian, thanks for the detail information, we can reproduce the performance issue, we will check how can we improve the performance.

1 0

replied on May 27, 2016

Thank you

0 0

replied on May 31, 2016

Hi Xiuhong,

Have you had any luck with this?

Thanks

Ian

0 0

replied on May 31, 2016

Hi Ian, our developers haven't gotten time to work on the improvements yet. I have added it to our to do list with high priority. Developers will check this after they finish their current tasks.

0 0

replied on June 1, 2016

Thank you

0 0

You are not allowed to follow up in this post.

Question

Question

FORMS calculations

Answer

Replies

Sign in to reply to this post.