CI FULLTEXT pagination

[eluser]smartweb[/eluser]
Hi,
I have a database, which has 1.5 million records. I need to constantly query the database and generates the paging record. Who can tell me how to write the T-the sql?

The table structure is as follows

CREATE TABLE IF NOT EXISTS `test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(200) DEFAULT NULL,
`body` text,
PRIMARY KEY (`id`),
FULLTEXT KEY `title` (`title`,`body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=86 ;