How to not load all database records in my TListbox in Firemonkey Delphi XE8 -


i have multi device project in delphi xe8. have tlistbox component load database records.

the problem list can big , loading take long. want load partially , when scroll down load new records. how do that?

right load every record of table using tfdquery.

update: after timing have realized problem doesn't lay loading records database, rather creating tlistboxitems in tlistbox. still want pretty same, load database records not create tlistboxitems of them.

from embarcadero wiki on tfdquery can set blockreadsize

for bde-enabled datasets, setting blockreadsize causes dataset fetch database information in blocks of blockreadsize records, buffers. minimizes traffic between application , database server.

another thing can try fetchoptions of tfdquery have rowsetsize property

i don't have @ moment firemonkey can test this.


Comments

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

php - .htaccess mod_rewrite for dynamic url which has domain names -

Website Login Issue developed in magento -