How to handle/scale in case of sudden increase in database queries due to high (unexpected) traffic at peak times? [closed]
I am not an expert in DB so please help in this. 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 ...
What VARCHAR sizes should be used for first and last names, phone numbers (preferably international), email adresses, urls, dictionary words and file names? Edit: Zapped the introductory phrase to ...