Improve query response with SQL Server.
If you are using jTDS driver to communicate with your logFaces SQL Server database and your database is very large and you experience slow responses from some (or most) queries, one of the things you can try to improve is to modify prepareSQL parameter in driver connection string. This may not apply to all deployments, but chances are that it will greatly improve the response times right away.
Open hibernate configuration file your server is using and append prepareSQL parameter like shown below:
hibernate.connection.url =
jdbc:jtds:sqlserver://host:port;prepareSQL=2;DatabaseName=lfs;...
