I'm going crazy here, in the past 4-5 years i switched hosting companies over 20 times because my site overloads and gives me & my visitors a database error everytime I get 2000 or 3000 visits , i have a sport site so everytime there is a game people will rush my site to see the updates and stuff. So everytime there is a big game my site is out of order.
I tried: Shared hosting, Premium Shared hosting
Now i have a VPS hosting but its not helping either.
i tried plugins link WP Super cach, i tried optimizing the site and removing all kinds of plugins, but nothing works.
I think even if i get a detecated server i will have the same problem with wordpress, do you guys have anything or tips that can help me?
Or wordpress is just not for my kind of site that drives alot of traffic?