B4J Question pagination for TableView or B4XTable

[giannimaione]

i have a table with over 10000 records;

i don't want execute a unique "select * from tablename....." but
i am able to create a classic "pagination"
exemple:
<< first page | < previous one | >next one | >> last page
and with sql query "select * from tablename ....... limit 5, maxRows"
maxRows indicate a max number of rows for page of table (TableView or B4XTable)

how to calculate a max number of table (for single page) when user resize a form/layout ?

 

[Erel]

B4XTable is always paged based. You don't need to do anything special.

 

[giannimaione]

Hi Erel,
a small example for my doubt.
with NO MAXIMIZE and rowFORpage = 15, it is ok.
but when resize or maximize form, how to recalculate value of rowFORpage ?
B4XTable is good, but my database (mysql) is biggest; now i think over 10000, but later record they will be many, many.
with B4XTable I have to read all the data together?

 

[giannimaione]

solved ???
your opinion ?