tags:

views:

31

answers:

1
+1  Q: 

What is the cs_PostViews Table used for in Community Server

I'm running Community Server 2.1 at the moment. My cs_PostViews table is at 200MB. What is the exact use of this table. Is it safe to truncate?

A: 

Found out myself.

This table holds a list of every single unique URL that was requested and served. I.e. no 404 type URLs and the number of times it has been requested.

I ended up truncating this table with no ill effects so far.

Ray Booysen  2009-01-10 23:11:08

related questions

Table Column Formatting
How do you truncate all tables in a database using TSQL?
how to see the schema of a db2 table (file)
Tools for refactoring table-based HTML layouts to CSS?
Page working in FF, not in IE, where to start
Hiding table rows without resizing overall width...
DIV with overflow:auto and a 100% wide table problem
For tabular data, what renders faster, CSS or <TABLE>?
I need my html table's body to scroll and its head to stay put
How to line up items of varied length in a resizable space in CSS?
CSS to make a table column take up as much room as possible, and other cols as little
Best approach for sortable table with a lot of data
A more advanced table/spreadsheet SWT implementation
JSF how do I retrieve the selected rows of a woodstock table
How to scroll only the right side of a table, listview, or datagrid?
Make a div fill the remaining screen space
How to stretch an HTML table to 100% of the browser window height?
SqlServer create table with MySql like auto_increment primary key
Why not use tables for layout in HTML?
Should Tables be avoided in HTML at any cost?
HTML drag and drop sortable tables
CSS overflow table row positioning
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)
Configurable Table Prefixes with a .Net OR/M?
SQL Table Aliases - Good or Bad?