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

Question

Question

Database lookup slow or not populating values some time

Forms Version 10
Updated January 6, 2017
asked on January 4, 2017

Hi,

I am using lot of store procedures to do lookup on a form.  The field value gets populated some time and some time the field is empty.  If I refresh the page then it starts to appear. 

Does anyone have an idea on how many lookup can be used in a form?   I see that the form slows down as you have more lookup.  

Does lookup runs in an order of the sequence we create on the form?

 

I am using Forms 10.1.0.642

0 0

Replies

replied on January 5, 2017

Hey AJ,

Regarding the amount of lookups you can have before experiencing performance slowdowns. This is really a "it depends" kind of answer based on a variety of factors (i.e. the complexity of the stored procedures/lookups).

Forms does try to process lookups as fast as it can, but the browser has a limit on how many connection you can make at a time. So you must wait for some to come back before the next set it sent. You can take a look at this link for further information or you can also check the activity yourself with Fiddler.

As for the second point regarding the sequence of lookups. The order matters if say the input in field 1 triggers a lookup to populate field 2, which then does the same for field 3. Otherwise the order does not matter.

In the first scenario, we send the order during the lookup and older value should not mess with the newer value.  We do not know when the lookup will return so how it looks to the user might change.  For example if you get the newer value returned first it will change one time.  But if the older value comes first and then the newer it should flip twice.  But they should end on the same value.

Hope that helps!

Cheers,
Kevin

1 0
replied on January 5, 2017

Thanks Kevin,

 

The store procedures are not too complexed.  I have about 20 lookups on the form.  Also a collection on the form with lookups.  After 5-6 rows, when you add a row it slows down as well.  When the form loads I see the cpu usage on the forms server goes above 20% then it comes down. Any other suggestions?

This is for one of our new customers and they are starting to hate it.

0 0
replied on January 6, 2017

One avenue to try would be to remove all the lookups and test your performance and then re-insert them one by one. It could  also potentially be an issue with the collections on the form. However, without access to the Form, the associated database, and stored procedures/lookups it is hard to pinpoint. I would suggest opening a case with Support and they may be able to help you resolve it. Otherwise someone from the Forms development team may be able to provide a resolution if it is escalated.

1 0
replied on January 6, 2017

Also, what version of Forms are you using currently? There have been a few fixes in 10.1 update 2, which would increase performance in relation to lookups.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...