Quote:
Originally Posted by jjshabado
How are you querying this?
Possible better options off the top of my head:
* (user, zip_code) where user can be duplicated and you only have rows for where the zip_code would be true. If its frequently changing, could maybe do (user, zip_code, is_selected) to avoid needing hard deletes.
* (user, list_of_zip_codes)
Its not frequently changing.
I am not sure that I follow. So a separate table for each user? Its better for the zip code issue, but seems like I would have a **** ton of tables that way...