Clear activity stream but keep last 10 updates per user

That is wonderful, thank you Stalski. As mentioned a similar concept exists at http://drupal.org/project/activity :)

fabulous! looking so forward Staski, thank you!

Stalski, I will test today but in the meantime you can see the settings at admin/settings/activity/settings

and have attached a screenshot and believe the code is in activity.admin.inc

/**
 * Form builder to dispaly settings for activity module
 */
function activity_settings_form(&$form_state = NULL) {
  $form['activity_expiration'] = array(
    '#type' => 'fieldset',
    '#title' => t('Activity Expiration Settings'),
    '#element_validate' => array('activity_expire_validate'),
  );
  
  $form['activity_expiration']['activity_expire'] = array(
    '#type' => 'select',
    '#title' => t('Activity log purge'),
    '#description' => t("Allows you to set a time limit for storing activity records. Select 0 to keep all activity records."),
    '#options' => drupal_map_assoc(array(0, 3600, 7200, 14400, 21600, 43200, 86400, 604800, 1209600, 2419200, 7257600, 15724800, 31536000), 'format_interval'),
    '#default_value' => variable_get('activity_expire', 0),
  );
  
  $form['activity_expiration']['activity_min_count'] = array(
    '#type' => 'select',
    '#title' => t('Minimum Activities'),
    '#description' => t('This is the minimum number activities that the user must have created before deleting any old activities.'),
    '#options' => drupal_map_assoc(range(0, 200, 5)),
    '#default_value' => variable_get('activity_min_count', 0),
  );
  

not sure if the following is part of it ..

/**
 * Batch deletion step.
 *
 * @param $aid
 *  The actions.aid for this template.
 * @param $batch_context
 *  The context array for this batch operation.
 */
function activity_batch_delete($aid, &$batch_context) {
  if (!isset($batch_context['sandbox']['last_activity_id'])) {
    $batch_context['sandbox']['last_activity_id'] = 0;
    $batch_context['sandbox']['progress'] = 0;
    $batch_context['sandbox']['max'] = db_result(db_query("SELECT COUNT(aid) FROM {activity} WHERE actions_id = '%s'", $aid));
  }
  $limit = 200;
  $activity_to_be_deleted = db_query_range("SELECT aid FROM {activity} WHERE aid > %d AND actions_id = '%s' ORDER BY aid ASC", $batch_context['sandbox']['last_activity_id'], $aid, 0, $limit);
  $activity_ids = array();
  while ($row = db_fetch_object($activity_to_be_deleted)) {
    $activity_ids[] = $row->aid;
    $batch_context['sandbox']['last_activity_id'] = $row->aid;
    $batch_context['sandbox']['progress']++;
  }

  activity_delete($activity_ids);
  // Check if not finished.
  if ($batch_context['sandbox']['progress'] < $batch_context['sandbox']['max']) {
    $batch_context['finished'] = $batch_context['sandbox']['progress'] / $batch_context['sandbox']['max'];
  }
  else {
    // If finished, delete the sandbox.
    unset($batch_context['sandbox']);
  }
  
}

/**
 * Batch regeneration step.
 *
 * @param $aid
 *  The actions.aid for this template.
 * @param $hook
 *  The name of the hook being recorded.
 * @param $op
 *  The op for the hook being recorded.
 * @param $batch_context
 *  An array representing the context for the batch operation.
 */
function activity_batch_regenerate_step($aid, $batch, $hook, $op, &$batch_context) {
  $module = activity_module_name($hook);
  $info  = activity_get_module_info($module);
  $load_callback = $info->context_load_callback;
  $limit = 50;

  // Set up the sandbox for the regeneration.
  if (!isset($batch_context['sandbox']['list'])) {
    $batch_context['sandbox']['list'] = $batch;
    $batch_context['sandbox']['max'] = count($batch_context['sandbox']['list']);
    $batch_context['sandbox']['progress'] = 0;

    $parameters = db_result(db_query("SELECT a.parameters FROM {actions} a WHERE aid = '%s'", $aid));
    $batch_context['sandbox']['parameters'] = unserialize($parameters);
  }

  $count = 0;
  foreach ($batch_context['sandbox']['list'] as $key => $event) {
    $context = array();
    if (++$count > $limit) {
      break;
    }
    else {
      $context = $load_callback($hook, $op, $event['id']);
      if (!empty($context)) {
        $context += array(
          'created' => $event['created'],
          'actor' => $event['actor'],
        );
        activity_record(NULL, $context + $batch_context['sandbox']['parameters']);
      }
      $batch_context['sandbox']['progress']++;
    }
    unset($batch_context['sandbox']['list'][$key]);
  }
  // Check if not finished.
  if ($batch_context['sandbox']['progress'] < $batch_context['sandbox']['max']) {
    $batch_context['finished'] = $batch_context['sandbox']['progress'] / $batch_context['sandbox']['max'];
  }
  else {
    // If finished, delete the sandbox.
    unset($batch_context['sandbox']);
  }
}

Hope this helps some and will revert asap with results :) Thank you so much Stalski!

also found this is activity.module

/**
 * Implementation of hook_cron().
 */
function activity_cron() {
  // default is 2 weeks 0
  $expire = variable_get('activity_expire', 0);
  $min = variable_get('activity_min_count', 0);
  if (!empty($expire) && empty($min)) {
    db_query("DELETE m, at, aa, a FROM {activity} a
             LEFT JOIN {activity_access} aa ON aa.aid = a.aid
             INNER JOIN {activity_targets} at ON at.aid = a.aid
             INNER JOIN {activity_messages} m ON m.amid = at.amid
             WHERE a.created < %d", $_SERVER['REQUEST_TIME'] - $expire
    );
  }
  elseif (!empty($expire)) {
    // SELECT members with the min number of activies and they have an min(created) older then the expire
    $uid_sql = "SELECT uid, min(created) as min, count(aid) as count FROM {activity} GROUP BY uid HAVING min < %d AND count > %d";
    $uid_result = db_query($uid_sql, $_SERVER['REQUEST_TIME'] - $expire, $min);
    $uids = array();
    while ($uid_obj = db_fetch_object($uid_result)) {
      $uids[] = $uid_obj->uid;
    }
    
    if (!empty($uids)) {
      // DELETE where uid IN () ^^ AND a.created < expire
      $args = array_merge($uids, array($_SERVER['REQUEST_TIME'] - $expire));
      db_query("DELETE m, at, aa, a FROM {activity} a
             LEFT JOIN {activity_access} aa ON aa.aid = a.aid
             INNER JOIN {activity_targets} at ON at.aid = a.aid
             INNER JOIN {activity_messages} m ON m.amid = at.amid
             WHERE a.uid IN(" . db_placeholders($uids) . ")
             AND a.created < %d", $args
      );
    }
  }
}

Wow Stalski, thank you so much, so far running perfectly! You are a Super-Star! Will revert if anything changes, but looking very good :)