[Georgee]

hello,

 

I have 5000 records and I am using the "datatables" theme:

$crud->set_theme('datatables');

The problem is that when I load my website, it first loads all records (it takes a little time)

and then cuts the records and creates the pagination.

 

 

how do I avoid loading all records, but just the first page?

[Georgee]

anybody able to help with this issue?

hope I described it clearly!

[davidoster]

Try this, 

$this->db->limit();

Lets you limit the number of rows you would like returned by the query:

$this->db->limit(10);

// Produces: LIMIT 10

The second parameter lets you set a result offset.

$this->db->limit(10, 20);

// Produces: LIMIT 20, 10 (in MySQL. Other databases have slightly different syntax)

or this http://www.grocerycrud.com/documentation/options_functions/limit

e.g. $crud->limit(10);

[Amit Shah]

well.. but defies the requirement - whats he gona do with the rest of the records when he needs it my friend?