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?
         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.
