Speed problem on servers

On servers, depending on the menu item,

When you say menu item does mean a simple Grid or Grid/Record?

Are you using SQL server authentication for all connections?

You may have a situation when:

Lookup within the record uses widows authentification
The user logged in to the server has no access to the database therefore lookup is failing silently
The timeout can be long

The item type is set to "Record". The users working with it are in a group which have db_datareader and db_datawriter on the repositoy and the datatables. But in the connection I have entered username and password.

For those who are having similar problems, the issue was addressed by removing comments from SQL and using the 64-bit version instead of 32-bit.

We will add notes about not using comments inside SQL statements to the documentation

Thank you for the support. The speed difference with our old version is very clear. I didn't think it would make that much of a difference. With the current version the described query with ATE on the server also takes only about 7 seconds instead of 3 minutes before.