I’ve got a lot of data (~75k records) that won’t fit into a single table, so I need to separate it out into multiple tables. It’s basic contact info (name, address, city, state, zip, phone, etc). We’re doing a zip-code search on the front-end (via th...
We’re on Enterprise. We have a 50k row limit per table.
I’m considering just breaking them out by zip range in batches of 10k. This way I don’t need to look anything up and I can just determine which table to look at by the first digit of the zip cod...
