Does instant search have a lot of processing power?

Question

I was wondering if an instant search using jQuery could cause a massive load on the database (MySQL). I know that there are many factors to consider, but for argument, let's say you have 30,000 entries to look at?

Answer 1

Indexing

Indexing helps, but indexing also slows down INSERT / UPDATE / DELETE ...

MySQL also limits the amount of space that you can use to index columns in a table , and depends on the type of engine:

• MyISAM : 1000 bytes
• InnoDB: 767

.
, SO TEXT , ~ 100 . , , VARCHAR.

, LIKE . , (FTS), MySQL MATCH .. AGAINST , Sphinx. , .

Answer 2

30 000 SQL , indexed. , . .

Answer 3

. , ?

Javascript, , , , . 3 - 4 , . , , .

, .

Answer 4

It depends on how you created your database. Indexes will matter, and the columns you select will do that too. The last thing you should consider is the search algorithm. If you just use where or like arguments to allow keywords, I think everything will be fine, but if you are after a lot of content, then you should probably consider MySQL's full-text search function.