We are planning to create two tables named prjcity and prjlocations for our application. (attached below) The application performs mainly the "select" queries for these two tables.Below are my questions about this implementation:
1. What is the performance effect if we define a relation for 'comments' field between two tables?
2. If we define above relation, is there any optimized select query for this type of relation? (any guideline welcomes)