"One thing we neglected to discuss or consider was the long-term consequences of using mod_log_sql. What happens as you accumulate more and more data? Sure, we mentioned the possibility of adding indexes to make some queries faster, but indexes only help so much. The real problem is that the default logging format for mod_log_sql is very simple, so as to be efficient for real-time logging. The tradeoff, however, is that it's not space efficient. As time goes on, the data can become quite large, difficult to manage, and slow to query."
(Submitted by Noel Sun Mar 21, 2004 )
Our content can be syndicated: Main page Mac Page
Copyright 1999-2005 Noel Davis. Noel also runs web sites about sailing and kayaking.
All trademarks are the property of their owners.
All articles are owned by their author