Show
Ignore:
Timestamp:
05/31/07 14:46:59 (2 years ago)
Author:
hagedorn
Message:

Reporting system: Fixed significant performance problem with summary and timings views.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/bcfg2/src/lib/Server/Reports/reports/sql/client.sql

    r1942 r3212  
    1 CREATE VIEW reports_current_interactions AS SELECT x.client_id AS client_id, reports_interaction.id AS interaction_id FROM (select client_id, MAX(timestamp) as timer FROM reports_interaction GROUP BY client_id) x, reports_interaction WHERE reports_interaction.client_id = x.client_id AND reports_interaction.timestamp = x.timer 
     1CREATE VIEW reports_current_interactions AS SELECT x.client_id AS client_id, reports_interaction.id AS interaction_id FROM (select client_id, MAX(timestamp) as timer FROM reports_interaction GROUP BY client_id) x, reports_interaction WHERE reports_interaction.client_id = x.client_id AND reports_interaction.timestamp = x.timer; 
     2 
     3create index reports_interaction_client_id on reports_interaction (client_id); 
     4create index reports_extra_interactions_client_id on reports_extra_interactions(interaction_id); 
     5create index reports_modified_interactions_client_id on reports_modified_interactions(interaction_id); 
     6create index reports_client_current_interaction_id on reports_client (current_interaction_id); 
     7create index reports_performance_interaction_performance_id on reports_performance_interaction (performance_id); 
     8create index reports_interaction_timestamp on reports_interaction (timestamp); 
     9create index reports_performance_interation_interaction_id on reports_performance_interaction (interaction_id);