mysql --user=yoursqlusername --password=yourpassword --database=yourdatabase -e 'TRUNCATE TABLE video_history'
Crontab that
Did that on my box too.
]]>$this->db->query("INSERT INTO #__video_history
Will certainly free up the SQL a little, like you said there's always analytics or Woopra which is what I use for tracking.
]]><?php
defined('_VALID') or die('Restricted Access!');
require '../libraries/bootstrap.php';
set_time_limit(0);
$db = VF::factory('database');
$db->query("DELETE FROM #__video_history
WHERE view_date < '".date('Y-m-d h:i:s', strtotime('10 days ago'))."'");
VF::close();
?>