Website performance optimization

1. Configure apache on the server and set up browser cache to reduce requests to the server;
2. Set up static pages or use redis and memcache to cache content with a lot of queries;
3. Optimize the database and query a lot of content Use the MyISAM engine; check whatever fields you want to query, do not use * to query all; do not use join statements; build indexes appropriately; use limit appropriately.
4. In-site search can be done directly using Baidu in-site search, which improves performance and reduces server pressure

5. Use sphinx full text search