Hello,
I have a situation in my app where I need to decide whether to keep all of a certain type of data in one table (normalized) or separating it into multiple tables. The table could get up to about 10,000 rows, or I could separate that into around 25 tables of approximately 400 rows each (the tables would be created intermittently based on user input as different types of data are added by the user). Normally I wouldn’t worry on a computer but I thought I should check if one table of 10,000 rows would cause noticible delays of a second or more on older phones when searching and returning 300-500 rows with multiple conditions.
If multiple tables are used, data would only be pulled from one table at a time with no conditionals.
Thank you,
Eric