Search In All Models (Db) ?!

Yii 1.1 General Discussion
1

Hi,

I searched google and Yii site, but could not find an answer for my question … how to search the whole site for content … the site has multiple models (article, news, ads, special file, reports) how to search in all of this models ??

Thanks

2

Create an aggregate table view from all your tables and then do the search against the table view.

3

If its a big site I strong suggest you to look into one of the full text search solutions, I personally use Elasticsearch

4

There is over 100K record (different content type) aggregating it in one table will slow down the search, unless it based on indexing.

@alirz23

do you tutorial for that ?

5

@marvix do a google lookup or go to the website the docs is pretty good and they have awesome screencasts