Explain each of these types of joins:
- Inner Join
- Outer Join
- Left outer join
- Right outer join
- Full outer join
- Cross join
Explain each of these types of joins:
Imagine a scenario where your website's database can only handle 1,000 queries every second, and your traffic has grown enough to product 1,500 queries per second at peak times.
What can you do to deal with this problem in the short term? What's a long term solution to deal with ongoing growth in traffic?