Data tab

I suppose if one is looking at 100.000 records, NEXT button should be logically enabled? It is not.

Sure, if your maximum is high enough, in Tools > Preferences > Grid formatting:

I have default settings. my idea on NEXT would be LIMIT 100000,200000 etc Don't want to load 1.000.000 records to see last few, don't want to write query extra for that-->

From time to time I do refresh on data tab to see amount of records filled in background process or more like to check if filling is in progress.

For all occasions it would be nice to have a warning, upon refresh/apply filter, msg box would be fine: Maximum rows displayed