I have a stored procedure which returns results in ~ 1 second when run directly from sql server, however it takes > 10 seconds to return results within a Laserfiche Form. Whenever I have the lookup enabled, it takes about 5 seconds to even add a row to a table. I have no idea why it's so slow, does anyone have any suggestions as to what I should look to improve? I notice that if I check the "Show Auto Fill Button", the form works much quicker - however no auto fill button appears... I would ideally like to hide it, but not if it's going to essentially make this form useless. I'm working in Forms 10.2. Any suggestions what I should try, or has anyone else experienced a similar problem?

Thanks