Web Products (WCM, Web Client and Webdrawer)
cancel

Web Client search fails with Sql Query Timeout exception RM 8.1

Shimna
Contributor.

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?

Thanks in advance

2 REPLIES
JanMartin
Honored Contributor.

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.

Highlighted
Shimna
Contributor.

Re: Web Client search fails with Sql Query Timeout exception RM 8.1

Tweaking the database finally seems to work. Followed instructions based on the execution plan from sql server to add index to the db.

Thanks for the help.