It's more about Sql (design) than B4x. Number of rows doesn't matter. Can you provide us with more info (db structure, indexes, sql statement)?
Thanks Kmatle,
My friend and I use same database and same query method for each project.
We compare two projects (my b4a android app and my friend android app that is created with MVC technique).
Both our sql's query design and loading time is not different in same android device.
But after query from database, binding result info into listview or table view is different.
This fact is cleared when results is more than 10,000.
I think I bind all result info into my view.
But his app loaded only viewed port items (15 rows) at a time.
I think there is a way in b4x.
I love b4x programming and I do my this project with b4x.
Thanks.