How does PHP search for large amounts of data?

There are hundreds of thousands of of data in the MySQL database. How to search with PHP?
Be fast. Search for the name of the book

Reply to discussion (solution)

MySQL inside, why use PHP search?

Do website AH ~

Only hundreds of thousands of, you need to consider the database optimization, such as index, table partition, Master and slave.

Only by rationalizing the structure of the data table, or by making the query statement simplify some additional requirements ...

Hundreds, it's not too much. MySQL is easy to handle. Of course, if your SQL statement is not well-written, it will be very slow. You can take a specific SQL statement and ask you to ask how you are going to solve your problem.

Reasonable index, reasonable table structure, try full-text index.

1. Index
2. It only takes a few seconds to pick up the index

If the light database takes a few seconds, plus the speed limit, the front page and other factors, then the user opens the page may have to wait more than 10 seconds
Better keep the database in less than 1-2 seconds.

First, you built the index no, second, is there a memcache?

1. Use the full TEXT INDEX provided by the MyISAM engine;
2, using SOLR.

