Kbase P134322: How do I improve the performance of my Analytics dictionary?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/08/2008 |
|
Status: Unverified
GOAL:
How do I improve the performance of my Analytics dictionary?
FACT(s) (Environment):
EasyAsk Versions
FIX:
Regularly delete the information in your Events and Sessions table - only keep x number of days of data, whatever your company determines is appropriate, possibly 90 days, possibly 180 days.
Good index columns on the Sessions tables are session id, timestamp, dictionary.
Good index columns on the Events table are session id, timestamp, event code, and quantity.