Company directory: how to optimize search?

A

Andrey Troshkov2014-10-21 10:13:19

PHP

Andrey Troshkov, 2014-10-21 10:13:19

Good day.
I need to make a website - a directory of companies (PHP, MySQL). The main function of the site is to search for companies. There is one field where the user can enter the name / category / phone / skype / company website, etc. and start searching. The system searches the database for suitable companies and displays them. The problem is that there are several related tables and a fairly large amount of information (more than 300 thousand companies). I have never dealt with such projects and would like to ask experienced programmers for advice: how to optimize the search and make it fast?
Thanks a lot.

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

F

FanatPHP, 2014-10-21
@FanatPHP

sphinxsearch.com

M

My joy, 2014-10-21
@t-alexashka

elasticsearch

A

Alexey, 2014-10-21
@HaJIuBauKa

Correctly set up indexes and relationships between tables (secondary keys).
I think you know how to make requests?

A

Andrey Troshkov, 2014-10-21
@AndyMarrel

Thank you, I will dig in this direction. Already installed a sphinx on the dev machine and somehow managed to get the search result using phpapi.