v 1.3.3 grocery CRUD - an automatic Codeigniter CRUD

[eluser]web-johnny[/eluser]
[quote author="fabgonber" date="1310808701"]Grocery Crud is slow with a lot of data (900 records) ... When the table has a lot of rows, grocery do a big select and next paginate the result. This big select it's slow...

Ideas? anyone has a example with external pagination (not grocery ajax pagination) and limit with offset? i would like do:

Code:

function full_example($page = 0)
{
        $limit = 50;
        $this->grocery_crud->set_table('customers')
             ->set_subject('Customer')
             ->display_as('customerName','Name')
             ->display_as('contactLastName','Last Name');

        $this->grocery_crud->required_fields('customerName','contactLastName');
        $this->grocey_crud->limit($limit,$page*$limit);
        $this->grocery_crud->render();
}

but don't work... i feel the problem is in $page parameter and grocery crud ...[/quote]

This only happens on the theme "datatables" . It is a theme that works with the client side datatables. Flexigrid ajax works fine. Here is an example of how fast grocery crud is with 1000 items and more complicated queries such as two multiple relations - http://www.grocerycrud.com/examples/inde...management, . I don't think it could be faster. If though you think something it is wrong create your own model ( see four posts up from here for how to create your own model and adding it to grocery crud ) - http://ellislab.com/forums/viewreply/914742/ - and share it