KnowledgeBase - How do I limit the memory usage or limit the table sizes found in FastTrends?
Article

How do I limit the memory usage or limit the table sizes found in FastTrends?

« Go Back
Products
Webtrends Legacy Products
Introduction
For products:
Webtrends Analysis Suite 7.0x
Webtrends Log Analyzer 7.0x

Last modified: 1/1/2011

Introduction:
To limit memory usage or to limit the size of any of the tables found in the FastTrends database, follow the steps below.
1. Exit and unload Webtrends (select the File menu, and choose Exit and Unload).

2. Navigate to the following location in the Webtrends installation:

\wtm_log\datfiles\

Note: To limit tables in FastTrends for Proxy Analysis or Streaming Media profiles, open the following corresponding directories:

\wtm_prox\datfiles
\wtm_stream\datfiles

3. In this directory, locate the file "limits.dat" and open it in a text editor.

4. An entry is listed for each table found in the FastTrends database. A sample is shown below:

chapter = Visitors & Demographics
name = Most Active Cities
limitable = N
limit = 1000000
tablenumber = 14
chapter = Referrers & Keywords
name = Top Referring URLs
limitable = N
limit = 1000000
tablenumber = 11

5. To limit a FastTrends table, change the limitable value from N to Y as shown in the example below:

chapter = Visitors & Demographics
name = Most Active Cities
limitable = N
limit = 1000000
tablenumber = 14

6. Save the changes and close the file.

7. Restart Webtrends.
Next Steps
More Information
 
Was this article helpful?

Please tell us how we can make this article more useful.

Characters Remaining: 255