I have a long list of names of 18,000 beneficiaries and I have used 5000 of this list to create a lookup table. This has made the android device response slower and difficult to select a from the options. I know about splitting tables but couldn’t understand what the end result of splitting tables would be. Does it mean that I would have multiple tables? This would defeat the aim of the table because it is a linked table.
Waiting for your respond