#3067: p.e.c. slowness issues after 0.10dev upgrade
----------------------+-----------------------------------------------------
Reporter: cboos | Owner: jonas
Type: task | Status: new
Priority: highest | Milestone:
Component: general | Version: devel
Severity: critical | Resolution:
Keywords: pec |
----------------------+-----------------------------------------------------
Comment (by jonas):
The slowness seems to come from the way sessions are stored and accessed.
The session table on p.e.c contains more than 240k rows. This in
combination with the lack of indicies on this table resulted in very poor
performance of a couple of queries, especially {{{Env.get_known_users}}}
and the query that purges old sessions.
The solution I'm proposing is to use a slightly less normalized session
table schema where the "last_visit" variable is stored in a separate
column (time). The table will also have indicies on the "sid", "time" and
"authenticated" columns.
The patch also adds an index for the time column of the ticket_change
table.
attachment:session.patch
--
Ticket URL: <http://projects.edgewall.com/trac/ticket/3067>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
