i think your proposal is reasonable. would we benefit from a well placed throttle here? if the site is under heavy load, stop trying to insert history records. -moshe On May 10, 2005, at 6:06 PM, Dries Buytaert wrote:
Would it make sense to change the "Discard watchdog/access log entries older than" settings to use the number of SQL table rows, rather than the number of days?
The problem? Again, at drupal.org, I had these set to "3 days" which I felt was short enough for the tables not to grow unwieldy. It wasn't until this week that I found out -- through extensive profiling -- that 3 days was too long.
The point? Unless you are a Drupal developer, you won't profile your site. This means, most users have no clue about how much data is kept track of, or why their site becomes slower and slower.
The question? How can we make it so that this doesn't happen? To me, having an option "Number of records to keep" rather than "Discard records older than" makes sense, because (i) it gives me control over the maximum number of table rows (ii) without having to worry about traffic bursts or a growing number of visitors (the cost is more likely to be constant over time). It gives me a clue about the performance/resource ramifications of certain features. Having a similar setting for the sessions- and history-table would make sense too.
Would this degrade or improve usability? Suggestions?
-- Dries Buytaert :: http://www.buytaert.net/