>I need to pool a large result (40000+) set from MySQL by using SQLEXEC().
>
>It take me about 10sec to download the full data and then the form only appear.
>
>How to fetch data in background, so the form can appear immediately after a few 100s of result downloaded.
>
>TIA.

Hi,

Try to use remote view or CursorAdapter class with FetchSize>0 and FetchAsNeeded=.F. .

Thanks,
Aleksey.