Ticket #14 (closed task: fixed)

Opened 4 years ago

Last modified 3 years ago

Query optimalisation

Reported by: WanWizard
Priority: low Milestone: 7.2
Component: ExiteCMS Core Version: 7.1
Severity: Tweak Keywords: core functionality speed

Description

Some queries are simply dead-slow, and need to be optimized. The Query debugging code has been extended to show the time (in milliseconds) it took to execute a query. Values over 500ms will be marked Orange, values over 2500ms will be marked Red.

Change History

comment:1 Changed 4 years ago by WanWizard

  • Status changed from new to assigned
  • Milestone changed from 7.0 to 7.1

Most 'alarming' queries have been rewritten. This check needs to be done every time prior to the release of a new version.

comment:2 Changed 4 years ago by WanWizard

  • Priority changed from trivial to low

comment:3 Changed 4 years ago by WanWizard

  • Version changed from 7.0 to 7.1
  • Milestone changed from 7.1 to 7.2

comment:4 Changed 3 years ago by WanWizard

  • Status changed from assigned to closed
  • Resolution set to fixed

I think this can be closed now. Most queries are examined and optimized. We will continue to do this during the entire development cycle.

Note: See TracTickets for help on using tickets.