What strategies do you use to optimize database queries for a system experiencing high write volumes?