How to implement a search on the site, where to store the search results?

Question

PHP

For example, there is a table with articles number of articles 100k+. The search is based on keywords plus or without checkboxes. On the page with the results, 10 or 20 links to articles will be displayed, if there are more results, then you will have to flip through accordingly. How to implement a search in a table? to pull out all the results at once, or to request as many as are displayed on the page using LIMIT? If you pull out all the results, then where to store them?

Answer 1

Why pull out everything if not everything will be shown? Naturally with the help of LIMIT.

Answer 2

how to implement? I like the sphinx. he will do everything himself. just feed it data.

Answer 3

You need 3 tables:
1. Data table (your data is a list)
2. Index table (unique words, parameters, etc.)
3. Many-to-many relationship table for the first two tables.
Additionally:
1. limit, of course, do not forget to specify at the end.
2. (If you need to display!) To determine the total number of records that match the query criteria, you can simply get count without any information.