[TYPO3-project-formidable] DATASOURCE logic isn't correct

Nikitin Sergey s.nikitin at prme.ru
Tue Apr 22 09:22:03 CEST 2008


I have a table fe_users there are about 1300 records.

Also I have a datasource with sql => SELECT * FROM fe_users WHERE pid=$pid

I found that it doesn't make a LIMIT query with LISTER's pager... WHY? 
refering to MYSQL doc 
(http://dev.mysql.com/doc/refman/4.1/en/limit-optimization.html) I found 
that we can count total result number just using COUNT(*) for all 
LIMITED rows (For ex LIMIT 0,10 COUNT(*) will return "10") or 
SQL_CALC_FOUND_ROWS for selecting all founded rows. And it will be one 
query for a one datasource. Please fix it in next revision, because it 
makes a huge memory usage with big tables.


P.S. Sorry for my english.


Best regards, Serg (nikitinsm at gmail.com)




More information about the TYPO3-project-formidable mailing list