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

Asked By 10 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #157791

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

qa-featured

          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.

Login/Register to Answer

Related Questions