[mahdi1986]

Hi dear,
I have a Table with 20 million record,
How can I prevent fill grid-view on page load???
I googled, but I can not find any solution
please help me
thanks

[Keith]

There's a discussion here that might be of help.

[mahdi1986]

No, I can't find solution

[Alexander Ast]

Did you try using pagination on dataprovider, that is taking to CGridView widget?

[mahdi1986]

Alexander Ast, on 17 June 2013 - 03:20 AM, said:

Did you try using pagination on dataprovider, that is taking to CGridView widget?

Yea,I use pagination, but I dont like fill grid view every page load, because my database have a heavy data

[Maurizio Domba Cerin]

For this you need to create a dataprovider that returns an empty data set check this thread for an idea - http://www.yiiframew...vedataprovider/

[mahdi1986]

Maurizio Domba, on 17 June 2013 - 03:56 AM, said:

For this you need to create a dataprovider that returns an empty data set check this thread for an idea - http://www.yiiframew...vedataprovider/

thanks for replay, I use this hint to my model, it is correct?

public function search()
	{
		// Warning: Please modify the following code to remove attributes that
		// should not be searched.

		$criteria=new CDbCriteria;
		$criteria->compare('dir',$this->dir,false);
        $criteria->mergeWith($this->dateRangeSearchCriteria('creation_time', $this->creation_time));
		$criteria->compare('request_agent_type',$this->request_agent_type,true);
		$criteria->compare('request_status',$this->request_status,true);
		$criteria->compare('tracking_no',$this->tracking_no,true);
		$criteria->compare('cif',$this->cif,true);
		$criteria->compare('account_number',$this->account_number,true);
		$criteria->compare('card_number',$this->card_number,true);
		$criteria->compare('national_code',$this->national_code,true);
		$criteria->compare('bank_code',$this->bank_code,true);
        $criteria->order="id desc";

        if(Yii::app()->request->isAjaxRequest)
        {
            return new CActiveDataProvider($this, array(
                'criteria'=>$criteria,
                'pagination' => array(  'pageSize'=>Yii::app()->user->getState('pageSize',Yii::app()->params['defaultPageSize']),
                )
            ));
        }
        else
        {
                 return new CActiveDataProvider('RequestSms',array('data'=>array()));
        }


	}

And I like don show gridview in init form, Is it way to hidden gridview in init view?
thanks for attension