The other possible cause to slow performance could be related to a possible bottle neck on the local network where the SQL database is hosted at. Can you tell me if the SQL server is hosting multiple databases by any chance? Are there any other applications that are experiencing the same or similar performance problem by any chance?

In the 7.1.0 build of OnTime, we have made a lot of performance increases especially when using the OnTime 2007 Remote Server to establish a successful connection to the database when working with the OnTime 2007 windows client. If you have the necessary remote server licenses in your OnTime product key, then you should be able to use the remote server connection method instead of the direct SQL connection to the database. The OnTime Remote Server which will transfer a lot less data across the local network thus increasing the performance when using the windows client.

Thank you,