Bug 6680 - The <insert#cached-href> tag performs a full table scan during gc.
: The <insert#cached-href> tag performs a full table scan during gc.
Status: RESOLVED FIXED
: Roxen WebServer
RXML Tags
: 5.1
: All All
: P3 (normal) normal
: ---
Assigned To:
:
:
:
  Show dependency treegraph
 
Reported: 2013-02-01 14:10 CET by
Modified: 2013-03-12 11:44 CET (History)
Scrum Prio: 488
In scrum?: Yes
Story included in sprints:
Unplanned in sprints:


Attachments


Description From 2013-02-01 14:10:36 CET
The function remove_old_entries() executes the query

  DELETE FROM <request_table> WHERE <time> - latest_request > ttl

the above query requires a full scan of the request_table, since there's no
useable index.

Suggested solution:

  Add an indexed column to the table containing the sum of latest_request and
ttl.
------- Comment #1 From 2013-03-12 11:44:33 CET -------
Checked in to devel.

Note

You need to log in before you can comment on or make changes to this bug.