Inserting the million rows to the memory db will take time.
B4XTable is a UI element. There is no good reason for it to hold 1m items. No user will want to go over a table with 100k pages. You should think how the user accesses the data and only load the relevant part each time.