Question

LF Forms extremely slow load times with multiple lookup Stored Procedures

Forms

Updated July 25, 2019

asked on June 11, 2018

I have a form that currently has 20 lookup rules, 9 of which are Stored Procedures and 11 are table/view lookups. Of those stored procedures, 6 of them are accessing the same stored procedure but using different input values from the forms. Prior to 10.36.1.635, the form would load in about 10-20 seconds, however since the update the form would load anywhere between 100-120 seconds. This is definitely not possible to deliver. I did narrow it down to those stored procedures causing the slow down.

Have anyone else had an issue with this and if so, does anyone know a way to fix this issue? Let me know if you need more information.

0 0

Replies

replied on June 12, 2018

I tried the second answer on this...

https://stackoverflow.com/questions/6585417/stored-procedure-slow-when-called-from-web-fast-from-management-studio

No real gain in speed though unfortunately

1 0

replied on June 12, 2018

I actually spoke to my CTO about this and I am attempting to run the monitor on SSMS to see the execution path for the stored procs. I will say that we recently updated the stored proc to include another variable in the search call. Possibly that caused an issue but we will see. I'll try out that second step with clearing the cache to see if that works.

0 0

replied on June 11, 2018

I have a similar issue with Forms 10.3.1. Loading data from a Stored Procedure is extremely slow.

I had to refine my Stored Procedures and merge them where possible to reduce load times.

In the end, I added a Spinner to show that the page was still loading data as a work around.

Running the Stored Procedure via SSMS takes only a few seconds.

0 0

replied on June 14, 2018

So I actually can not run those options to fix my problem. Unfortunately there are services running on the SQL server that I cannot clear cache. Is there an issue with calling out to a stored procedure on a form more than once?

0 0

replied on July 25, 2019

Hello,

Did you ever find a resolution here? I am having this issue on 10.3.0.975. I have a stored procedure that is set to run whenever the autofill button is clicked, however I can 100% replicate that if the stored procedure is in place, it causes the form initial load time to increase to more than 2 minutes.

Thanks,

Jason

0 0

replied on July 25, 2019

Jason,

I ended up triggering lookups to run only on conditions in Javascript. The page will still attempt to load a lookup, but with the value not being present in a lookup field, it does not run. This broke up the initial page load latency issue, but it is still taking some time during each lookup. That was the best solution I found so far.

1 0

replied on July 25, 2019

Thanks for the quick response Paul. That totally makes sense. The issue with the stored procedure I am using is, if the criteria field is blank, it simply excludes it from the search, but I would still want the search to run. I think the part I'm not understanding is, why does it run when the form loads to begin with. I wouldn't want it to execute until the autofill button associated with the field is clicked.

0 0

You are not allowed to follow up in this post.

Question

Question

LF Forms extremely slow load times with multiple lookup Stored Procedures

Replies

Sign in to reply to this post.