Is there a good library or integration with PS for live search on a large database?

Question

Database

Hello, we are planning a project with a large and constantly updated database. The cells that will contain the necessary information will be filled with approximately 1000 characters each. It is necessary that the user starts writing a request and cells are immediately loaded, the same or similar. At the same time, without paying attention to spelling and syntactic errors. There are a lot of examples of live search on the Internet, but I think that these examples do not fit the complexity of the project, and they search by coincidence one to one. Can you please tell me what can be integrated to solve this problem? It seems I saw somewhere that you can integrate Google search technologies to search the database, but I can’t find it again :(

Answer 1

Such things work quickly just because it is not a database that is used, but a cache with previously entered phrases.
You can smoke ElasticSearch, with fine tuning of indexes you can squeeze out not a small performance.