Open joelamltc opened 7 years ago
Go with search engine indexing (Elasticsearch etc... ) or buy a faster Sql server... This package is great but doing full-text search without indexes is terribly expensive.
It's based in the nature of a SQL-Server it isn't made for search - it's for related data storage. If you want to go for elasticsearch you can use https://github.com/elasticquent/Elasticquent or you use a service like algolia with https://github.com/algolia/algoliasearch-laravel - and I bet that there are plenty more options. But don't do a "real" search in a sql database.
Something like this.
The performance will become very shitty. Any suggestions?