Slow New Record Creation

[SpiroAu]

I have a server hosted app. It sends emails to clients but when a user send the email it queues it and then the server runs a script to send the emails. This all works fine. The issue I am having is as follows:

 

1. When creating a new e-mail (new record/request) there is about a 10 second delay when entering the first field in the table and then the rest of the fields that are updated is quick. If I cancel the record creation and then create the email again there is no delay when entering the first field

 

This only happens when access the server over a VPN into the rooms but not when accessing on a local PC in the rooms.

 

I assume this has something to do with SSL certificate authentication but not sure.

 

Can anyone shed light?

 

Thanks

[rivet]

If you are running a complicated ExecuteSQL calculation somewhere, it can be slow the first time it is hit. 

Edited November 18, 2023 by rivet

[SpiroAu]

I am not using ExecuteSQL in this table. There is on a single calculation field and nothing else so don't think this is the issue.

[Josh Ormond]

What is the calculation doing? If this calculation is triggering a large data grab from other tables or grabbing data from several relationship hops away, along with a lot of other necessary behaviors to make the calculation work, this can be the reason it's slow on the first action. After that, all that data would be cached, and appear much faster.