Edgewall Software
Modify ↓

Opened 15 years ago

Closed 15 years ago

#8896 closed enhancement (duplicate)

[PATCH] improve performance when searching tickets (postgres)

Reported by: Paul Laws <paul.laws@…> Owned by:
Priority: normal Milestone:
Component: ticket system Version: none
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

We have a database of around 8,000 tickets with around 25 custom fields. We found that after migration from sqlite to postgres the ticket search was taking anything up to 2 minutes to run. The attached patch reduced the time to search to around 1-2 seconds.

Attachments (1)

web_ui.py.patch​ (1.7 KB ) - added by Paul Laws <paul.laws@…> 15 years ago.
Patch to ticket search

Download all attachments as: .zip

Change History (2)

by Paul Laws <paul.laws@…>, 15 years ago

Attachment: web_ui.py.patch​ added

Patch to ticket search

comment:1 by Christian Boos, 15 years ago

Component: general → ticket system
Resolution: → duplicate
Status: new → closed

Oops, this ticket went unnoticed and in the meantime someone else reported the issue, also with a patch (see r9007).

Really sorry about that, but at least, you now deserve an entry in the THANKS file as well ;-) Please don't hesitate in the future to "make some noise" to get our attention. If we don't comment on a good patch within a week, something is wrong…

So, duplicate of #8935.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment
E-mail address and name can be saved in the Preferences .
Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.