Originally Posted by BestXXXPorn

Yeah I'm not seeing a major speed decrease on any sites which implement v4... more than likely there could be more complex calculations and queries in the new system as compared to v3, but that's a necessity when offering more functionality. If a site is running slow, it's not the software, it's the hardware. Most likely (since there isn't too much to change in PHP unless they need to add more webheads) it lies within the DB. I would recommend people get some beefier boxes for their DBs and certainly be running a Master / Slave / Slave if they're a large sponsor. There are so many settings in let's say MySQL that you should have a real DBA take a look at your system if it's running slow...

Are people that are experiencing this checking for slow queries and running explain to see where the bottleneck is? What does your HD I/O peak at on your DB boxes and how often? How much memory are you allocating to MySQL? Have you taken a look at the amount allotted to your thread cache, bdb cache, table cache? What about your key and join buffer sizes? Many people don't even know these exist. Additionally, what engine are you running on what tables? There's so much performance you can squeeze out of MySQL if you really know what you're doing...