In this third case we get to see some really fun stuff: The effect of ANALYZE on index selection for a three table join, an ORDER BY with LIMIT optimization, and documented evidence that what we'll fix makes a night and day difference for the better. The customer in this case runs a gaming website using the Neocrome Land Down Under website engine. The customer's website averages about 7,000 unique vistors and 150,000 pages views a day. The most popular forum averages 300 - 500 people online. At least, it does now; before the fixes we'...
查看详细内容 >>