Large number of rows in a couple of tables creates performance issue

Question

We've had our customer's site online for just over 4 months and we are experiencing serious performance issues (sometimes the site is simply no longer responsive). We've identified 3 tables which mig…