Question

Populating Table stops browser from responding when above 50 rows.

Forms Version 10

Updated September 26, 2018

asked on May 16, 2016 • Show version history

A customer is chosen from a drop down list, any matching rows from within a table in the background (sql) it will return all rows that match that customer. It works instantly with around 1-15 rows but around 50 rows it takes around 30 seconds, anything above that the browser goes into a not responding state/script has stopped responding. Sometimes in chrome you can hit the wait button a few times and the table will populate, but not always. IE (various versions) and Chrome are the tested browsers.

There is only 5 columns with data that it needs to return.

0 0

Replies

replied on May 16, 2016

Are you using Forms 10.0? Forms 10.1 has improved the performance for lookup to insert rows for table.

0 0

replied on May 16, 2016

10. I will update to 10.1 now and let you know of any changes.

0 0

replied on May 17, 2016

I have updated to the latest versions overnight.

It seems to have made a minor difference in speed, but anything that is still above around 50/60 rows still won't fill them out without locking the browser up.

It seems that about 1 second per row when it does get the data.

Any other hints I may be able to try?

Regards

0 0

View 3 previous replies

replied on May 17, 2016 • Show version history

I setup similar lookup rule and tested between 10.0 and 10.1: when there are 300 rows returned by lookup rules: it tasks 1 minute to add all the rows in 10.0, but only takes 10 seconds in 10.1 ( video from 10.1: http://screencast.com/t/Y4Y129jwWuss)

Can you try again after clear the browser's cache? If it still slow, you can open an support case with following information:

1. screenshot for the lookup rule configuration

2. record a video with the reproduce steps: open the form in Chrome and open Chrome developer tools and go to Network tab, choose from dropdown to get returned rows(we need to see the network log)

3. exported xml for the process.

0 0

replied on May 17, 2016

I have cleared the browser cache and is still slow.

I logged a support case this morning, with all information in a zip. Look up rules, field rules, template fields, copies of flat file source, css etc.

Yours would be as quick as I would expect mine to be.

I taht the network tab in dev tools open and it showed the following instantly, but took 40 seconds to show 35 rows.

I will work on sending a video also.

#173585 LF Case

net.JPG (38.41 KB)

| Download

0 0

replied on May 17, 2016

I will take a look for the support case.

0 0

replied on May 18, 2016

I can reproduce your issue with your process and data in Forms 10.1. It may because your form is more complicated than mine. I found the performance of your form can be improved if I remove the field rule which contains columns Action, Resolution and Condition.

We will do further investigation based on your process to see whether the performance can be improved. At the mean time, can you remove the field rule as a workaround?

2 0

replied on May 18, 2016

I have removed the field rules and it has sped it up. However the larger lookups still require that you press wait once in the browser as it still takes some time to process.

0 0

replied on May 18, 2016

This is a known issue for larger lookups, we will see whether we can do further improvements.

0 0

replied on May 18, 2016

The solution hasn't been deployed yet. Am I expecting too much for Forms to be able to handle this?

It is also is consistent with another previous issue when designing the form.

I previously had the form so that it would not display the resolution field unless the action field was not blank. That really caused performance issues and I removed that and just have it disolay both fields. I guess this could be along the same lines.

0 0

replied on June 10, 2016

We are experiencing the same issue.

Is there any solution or work arround yet?

0 0

replied on June 10, 2016

Hi, It is not fully resolved, but make sure you are running 10.1 That is an important thing.

I also had to remove most of the field rules too, I had a lot of hide this and show that rules.

These were really slowing it down. By removing most of those and updating from 10 to 10.1 I got a lot better speed, Although the form doesn't look and function as nice as originally designed, the core job still works. but in saying that anything that has maybe 100 or so rows, the browser will still stop responding, I click wait and then it will usually bring the rest in. But anything with several hundred rows still is too much for it.

Regards Gary

0 0

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

replied on September 26, 2018

This is an old thread and supposedly fixed with that update. However, I am still experiences an incredibly amount of latency with lookups and calculations in a table when adding even 4+ rows.

I tested in console and with autofill and lookups, 7 rows takes 30 seconds. With both turned off, it takes 3.3 seconds. Is there something that might have overwritten this "fix" since then?

0 0

You are not allowed to follow up in this post.

Question

Question

Populating Table stops browser from responding when above 50 rows.

Replies

Sign in to reply to this post.