Web Client search fails with Sql Query Timeout exception RM 8.1
The web client search fails when a user is trying to perform a search using two additional field parameters. The same search works on desktop client. On checking the logs it was found that the Sql query for web client search takes more time because the records are sorted. The sort option is required from a customer perspective and hence cannot be removed. The result set is relatively small. Around 100 records or so but overall the DB is huge and growing.
Is there any way to optimize or work around this issue?
Re: Web Client search fails with Sql Query Timeout exception RM 8.1
What is the string version of the query you're running?
There are a variety of things you can do to increase query performance, from enterprise studio select Schema -> Manage - you can check and repair any schema issues which may help. A db admin may be able to tweak other settings on the database to help.
Is throwing more resources at the SQL database an option?
You can of course increase the timeout, but taking more than 30 seconds to return a search result is usually unacceptable to users.