Createcountcommand And Limit

Why createCountCommand does not have applyLimit ?

I want to sql limit execution for max count in CActiveDataProvider

A solution given by qiang

http://www.yiiframework.com/forum/index.php/topic/7402-problem-with-cactivedataprovider/page__view__findpost__p__37536

But for many rows of the table may it slow down the performance (count uses createCountCommand)

Is there any other solution ?