Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Improve getTotalSiteUniqueVisits() execution time

Description

Improve getTotalSiteUniqueVisits() execution time

Environment

None

Test Plan

None

Activity

Show:

Nuno Grilo May 26, 2009 at 7:59 AM

Fixed in r60750.

SQL query was modified to take advantage of the new index (added to conversion script):

create index SST_EVENTS_SITEEVENTUSER_ID_IX on SST_EVENTS (SITE_ID,EVENT_ID,USER_ID);

This index creation will take several minutes to complete.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created May 11, 2009 at 4:18 AM
Updated December 22, 2014 at 10:51 AM
Resolved May 26, 2009 at 7:59 AM
Configure