Best proven ways to improve search performance [closed]

It's difficult to tell what is being asked he开发者_开发问答re. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

We are working on a website like www.justdial.com . Every State has Districts which have Cities which have Categories and subcategories.

Kindly suggest proven ways to improve performance.

---

• Add tags
• Create shorter standalone static index for popular queries.
• Create prepared static cached content for popular queries.
• Move (partially sort) popular queries to the beginning of the index.
• Optimize SQL queries with LIMIT, reduce number of JOINs and reduce number of string functions