Ticket #2619 (closed patch: done / applied)

Opened 3 months ago

Last modified 2 months ago

SQL query optimization

Reported by: kanru Owned by: somebody
Priority: normal Milestone: 1.1
Component: other Version:
Keywords: Cc:

Description

Optimize the queries used in Logger.py.

With this optimization I can get a performance boost; startup time reduced from 1min to several secs.

Attachments

sql_query_optimization.diff (9.0 kB) - added by kanru 3 months ago.
sqlquery_optimization.diff (4.5 kB) - added by kanru 2 months ago.

Change History

Changed 3 months ago by kanru

Changed 2 months ago by kanru

Changed 2 months ago by kanru

Updated patch.

This patch reorders the from clause and creates proper indexes.

Performance measured:

single query time reduced from 1.173822 sec to 0.017997 sec.

Changed 2 months ago by JoinTheHell

  • status changed from new to closed
  • resolution set to done / applied

Add/Change #2619 (SQL query optimization)

Author



Action
as closed
Next status will be 'reopened'
 
Note: See TracTickets for help on using tickets.