[quote]*For MySQL, CPU time is much less important than RAM and disk speed (MySQL PS uses local, raided, high-speed SAS drives).
Since it is not a potential bottleneck, on MySQL PS CPU time is approximate… though still proportional to your RAM level.
Can anyone elaborate on that? Is it saying that unless you’re performing pretty hardcore queries (multiple joins, sub-selects, etc) you’re not going to need it?[/quote]
What they’re saying is that most of the time, memory is the bottleneck to good database performance. So pay attention to the amount of memory that you think your application queries will need, not the CPU time they require.
I think this is dependent on both your own use and the vagaries of your shared hosting neighbors. I depend on caching of dynamic content as static pages for my performance so I don’t do a lot of hand-wringing over database performance.
DNS issues, if they affect your webserver, will affect your application. That said, strictly speaking since you get a local running copy of MySQL, DNS problems won’t affect your application’s ability to access the database. The fact that MySQL is local will also improve performance.
Free unique IP and $67 off with promo code [color=#CC0000]LMIP67[/color] or use [color=#CC0000]LM97[/color] for $97 off. Click for more promo code discounts