Two techniques for handling recursive relationships in MySQL

How much difference does adding an index to a database table make?

Full-text search with MariaDB

Using stored procedures in your web app