Проблемы с большими таблицами.

    public function getComments($only_published=true, $is_tree=false, $from_module = false) {
 
	if ($comment_id > 15) {$comtable = 'cms_comments';}
	else {$comtable = 'cms_comments_old';}
 
		$inUser = cmsUser::getInstance();
 
        $comments = array();
 
		global $_LANG;
 
        $published = $only_published ? 'c.published = 1' : '1=1';
 
        $sql = "SELECT c.*,
					   IFNULL(u.nickname, 0) as nickname,
					   IFNULL(u.login, 0) as login,
					   IFNULL(u.is_deleted, 0) as is_deleted,
					   IFNULL(p.imageurl, 0) as imageurl,
					   IFNULL(p.gender, 0) as gender
                FROM $comtable c
				LEFT JOIN cms_users u ON u.id = c.user_id
				LEFT JOIN cms_user_profiles p ON p.user_id = u.id
                WHERE {$published}
					{$this->inDB->where}
 
                {$this->inDB->group_by}
 
                {$this->inDB->order_by}\n";
 
        if ($this->inDB->limit){
            $sql .= "LIMIT {$this->inDB->limit}";
        }
 
        $result = $this->inDB->query($sql);
 
        $this->inDB->resetConditions();
 
        if (!$this->inDB->num_rows($result)) { return array(); }
 
        while($comment = $this->inDB->fetch_assoc($result)){
 
			$comment['level'] = 0;
			$comment['is_editable'] = $this->isEditable($comment['pubdate']);
			$comment['fpubdate']    = cmsCore::dateFormat($comment['pubdate'], true, true);
 
			if ($comment['guestname']){
				$comment['author']     = $comment['guestname'];
				$comment['is_profile'] = false;
				$comment['ip']  	   = in_array($this->config['cmm_ip'], array(1,2)) ? $comment['ip'] : '';
			} else {
				$comment['author']['nickname'] = $comment['nickname'];
				$comment['author']['login']    = $comment['login'];
				$comment['is_profile'] 	= true;
				$comment['user_image'] 	= cmsUser::getUserAvatarUrl($comment['user_id'], 'small', $comment['imageurl'], $comment['is_deleted']);
				$comment['ip']  		= ($this->config['cmm_ip'] == 2 && $comment['ip']) ? $comment['ip'] : '';
			}
 
			switch ($comment['gender']){
					case 'm': 	$comment['gender'] = $_LANG['COMMENTS_MALE'];
								break;
					case 'f':	$comment['gender'] = $_LANG['COMMENTS_FEMALE'];
								break;
					default:	$comment['gender'] = $_LANG['COMMENTS_GENDER'];
			}
 
			$comment['show']  = (!$this->config['min_karma'] || $comment['rating'] >= $this->config['min_karma_show']) || cmsUser::userIsAdmin($comment['user_id']);
			$comment['is_my'] = ($inUser->id == $comment['user_id']);
			if ($inUser->id){
				$comment['is_voted'] = $comment['is_my'] ? true : cmsUser::isRateUser('comment', $inUser->id, $comment['id']);
			} else {
				$comment['is_voted'] = true;
			}
			if ($inUser->id){
				$quest['is_voted'] = $quest['is_my'] ? true : cmsUser::isRateUser('quest', $inUser->id, $quest['id']);
			} else {
				$quest['is_voted'] = true;
			}
 
            $comments[] = $comment;
 
        }
 
		if($is_tree){
			$comments = $this->buildTree(0, 0, $comments);
		}
 
        return $from_module ? cmsCore::callEvent('GET_COMMENTS_MODULE', $comments) : cmsCore::callEvent('GET_COMMENTS', $comments);
 
    }