Crud: Pagination Problem

[ahmadronaghdev]

I Have 30,000 record in my table and create crud for this table but when laod this data i get error after minute

i check setModel Method in CrudPannel and select (*)

 public function setModel($model_namespace)
    {
        if (! class_exists($model_namespace)) {
            throw new \Exception('This model does not exist.', 404);
        }

        $this->model = new $model_namespace();
        $this->query = $this->model->select('*');
    }

i think its load all data then shown in table rather than select 10 last item and then select page 2
how can i fix this problem ?

[franciscocorrales]

Have you enabled AJAX ?

You have to add $this->crud->enableAjaxTable(); in your index() method. AJAX loading is not enabled by default.

You can read more here.