operations on result set ?

[eluser]Zeeshan Rasool[/eluser]
hello dear fellows,
I am in little problem that i need to implement some operations on result set. How can we do it in CI? i mean i have a result set after a long query getting result from multiple tables so can i make pagination on it . I got a solution that we can copy all results into another new table and then do what we need but results can be so much ... any idea ?
very thanks ...