Demos · Guide · Class Reference · Wiki · Extensions · Forum · Live Chat · Login

auto-count-sql-data-provider

AutoCountSqlDataProvider has the ability to use pagination without first counting all the rows, thus increasing performance.

AutoCountSqlDataProvider extends the CSqlDataProvider. It adds the ability to use pagination without first counting all the rows, thus increasing the performance when browsing large tables.

Requirements ¶

None

Usage ¶

# table_name has 15 rows.
 
$provider = new AutoCountSqlDataProvider(
    'table_name',
    new CDbCriteria(array('condition'=>'column1 is not null')),
    false,
    array(
        'sort'=>array(
            'attributes'=>array('column1','column2'),
        ),
        'pagination'=>array(
            'pageSize'=>10,
        ),
    )
);
 
$rows = $provider->fetchData();
# count($rows) == 10
# $provider->hasMore == true
# $provider->getTotalItemCount() == 10
$rows = $provider->fetchData();
# count($rows) == 5
# $provider->hasMore == false
# $provider->getTotalItemCount() == 15

Resources ¶

Blog post

Create extension

Downloads

» AutoCountSqlDataProvider.zip

See all »

License: New BSD License
Developed by: prekageo
Category: Database
Votes: +3
Downloaded: 254 times
Created on: Jul 21, 2011
Last updated: Jul 21, 2011
Tags: data provider

Yii Supporters

Clevertech supports Yii. Clevertech builds custom solutions to cut overhead, create relevant management reporting and deliver profits.
The Ext4Yii Framework is a professional PHP Yii extension which provides server-side ExtJS functionality.

auto-count-sql-data-provider

Requirements ¶

Usage ¶

Resources ¶

Be the first person to leave a comment

Yii Supporters