Hello,
We notice a lot of Latency/Ping when running our cloud client application. The issue occurs when the script calls SQL statements, such as a Select statement, followed by an update statement, for example when the user logs into the system, the User, Password is validated and then a record is inserted into the database the date and time they logged in.
Running this as a Normal/Local application takes milliseconds for the procedure to execute, but with the cloud application it can take up to 2 - 3 minutes.
Is there any settings/workarounds that can help speed up these SQL executions? For instance the IIS cache settings, Powerserver settings, etc.
We are using:
1) SQL Anywhere 17,
2) We have the "Don't Pool connection to this driver" set on the SQL Anywhere Connection Pooling, because we are using a temporary table that needs to be cleared when the client disconnects.
3) Our timeout Session is Session = 14520, Transaction 14400 and Request = 3600, MaxSpClientCache = 50.
4) We are using LongConnection in the SQLCA.dbparm, to keep the temporary table through out the connection until disconnected.
Thank you,
Andreas