Sphinx + ActiveDataProvider

Yii 2.0 General Discussions
1

Hi.

I generated sphinx model and crud with gii and have noticed one problem in list or grid views. When responce more than 1000 elements and I move to last pages I got error. Sphinx has total and total_found values and it looks like dataProvider use total for pagination. I’ve solved it like this:




$query = AnySphinxActiveRecord::find()->match($this->fieldName);

$count = $query->count();

$dataProvider = new ActiveDataProvider([

    'query' => $query,

    'totalCount' => $count > 1000 ? 1000 : $count

]);

May be is there better solution? As sphinx has its own query class. Thanks