Representing address

• how-to-design-the-database-schema-representing-address-elegantly
• Use first solution, If a country does not has any states, just add a dummy state (same as country name). Cache the data of city, state, country (which are not likely to be changes but frequently needed) in database (Query cache) or in server (using APC/memcached etc). Once cached, you wont need many joins thus making queries faster
•  the previous solution is related to the information given in the link
• best-practices-for-storing-postal-addresses-in-a-database-rdbms
• make address an entity and store it in a cache like redis or memcache
•