If users increased, search queries also increased..!!!How to Handle this change?

Asked By challamalli 10 points N/A Posted on - 05/21/2012

We have farm with 
2 WFE
1 Admin
1 Index
1 Query
10 K users used to fire 20 K search queries in a day

Now the user base is increased to 15 K users and 40 K Search queries

How would you handle this change?

• Status: Open
• Question Views: 800
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: MS SharePoint

Answered By Crag fresh 0 points N/A #157791

If users increased, search queries also increased..!!!How to Handle this change?

          Although programming matters like joining tables, field types, table relationship and coding is really important for this matter it still really more depends on the database engine/database and hardware resources that you are using.  Lots of queries consume also a lot of resources. If you are running lots of queries at the same time, you may not get the best result to your queries. You should limit the number of queries. For these lots of queries the best solution that I know will help you is to find for software or tools that makes you database queries faster.  Just like face book, they are using tools to make their mysql database work faster.

About Crag fresh

Questions
1

Answers
135

Best Answers
22

• Vote Up 0 Vote Down

• Posted on - 05/22/2012
• Question Category: MS SharePoint