Thanks for the quick response everyone. I think we'll look to implement a JS service that cleans up the data on a regular basis. I'm assuming even a user-defined service can get access to the JS database or possible the stats service has methods to call that we can utilize.
On Tue, Mar 8, 2011 at 10:17 AM, David Taylor <[email protected]>wrote: > On Tue, Mar 8, 2011 at 7:00 AM, Jeff Pierce <[email protected]> wrote: > > How do you reset the portal statistics that are being collected? > > > > I checked on a couple of pages but didn't see it. > > > > Also, are the flush parms the "frequency" of data collected? By that I > mean > > if I change these values will it reduce the size of the database file? > > > Statistics are not written to the database immediately. Instead the > stats are queued up in memory to be committed in batch to the database > at the configured interval per in the system properties: > > # Flush time in in Millisecond > portal.statistics.MaxTimePortalToFlush=300000 > portal.statistics.MaxTimeUserToFlush=5000 > portal.statistics.MaxTimePageToFlush=60000 > > > > Is there a way to set the "limit" on size? Ours has grown to be quite > > large. > > > No. It just keeps growing. You could issue a SQL statement to delete > or archive records older than a certain date > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
