SQL, pagination

iz MYSQL baze potegnem nekaj v smislu:

Select ...
group by ... having ...
Limit 0,20

To dela hitro. Za paginacijo pa rabim še vedet kolk recordov bi bilo brez LIMIT.

Vse skupaj sem dal v v eno bazno poceduro, ki vrne recordset od 0,20, in en return value, ki je zadevni count in izkaže se da je zelo počasno (zdaj, ko se je zapisov nabralo), ker moram pač:

select count(*) from

Select ...
group by ... having ...

Kakšna pametna misel ?

Za tole pa nisem vedel (-:

v mysql query browser:
1. v prvi zavihek, moj sql s SQL_CALC_FOUND_ROWS z LIMIT, in mi vrne 20 recordov, tako kot treba
2. v drugi zavihek SELECT FOUND_ROWS();, in mi vrne 1

EDIT:Malo sem bral help, zgleda da bi moral to spravit v eno globalno variablo:

The row count available through FOUND_ROWS() is transient and not intended to be available past the statement following the SELECT SQL_CALC_FOUND_ROWS statement. If you need to refer to the value later, save it:

mysql> SELECT SQL_CALC_FOUND_ROWS * FROM ... ;
mysql> SET @rows = FOUND_ROWS();

Ni mi čist jasno. Med 1 in 2 , zgoraj, po bazi ne delam nič.

?

nč ne pomaga, SELECT FOUND_ROWS(); zmeraj vrne 1,
kajpak ima c_sql znotraj SQL_CALC_FOUND_ROWS
pa tud če ne bi imel bi moral pa vsaj vrnit 20.

DELIMITER $$

DROP PROCEDURE IF EXISTS `getOnePageOfDataNew` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `getOnePageOfDataNew`(OUT i_result INT,
                                                                 IN  c_sql text,
                                                                 IN  c_limit VARCHAR(60)
                                                                 )
BEGIN

DECLARE tmpInt INT;

DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
BEGIN
  set i_result = -1;
END;

Set @i_count = 0;

SET @s = CONCAT(c_sql," ",c_limit);
prepare stmt from @s;
execute stmt;
DEALLOCATE PREPARE stmt;

SELECT FOUND_ROWS() into @i_count;
set i_result = @i_count;

END $$

DELIMITER ;

EDIT:tkole pa npr dela, čudno res ...

Select SQL_CALC_FOUND_ROWS id_galery
FROM galery_1
LIMIT 0,18

union

SELECT FOUND_ROWS()