These days more and more sites are suing #3 or #2 if resources are an issue. I personally prefer #3 myself but it's definitely more intensive than 2 and much more so than 1. However, as your site grows and people use other sites more, it2 or 3 seem to be a necessity to be competitive.
When implementing either of the db options expect to need more memory on your db server and potentially more issues related to corruption as your db is accessed more often.
Lastly, 10 days is my normal setting for #3.
|