Edgewall Software
Modify ↓

Opened 8 years ago

Last modified 2 years ago

#12909 new enhancement

Adding Ticket.select to bulk fetch records

Reported by: Jun Omae Owned by:
Priority: normal Milestone: next-stable-1.6.x
Component: ticket system Version:
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

When retrieving ticket records in custom query, QueryModule executes SELECT query to ticket_custom table N times a Ticket instance. That behavior is slow….

I think we could reduce it to 1 time with Ticket.select to bulk fetch records.

​th:ExcelDownloadPlugin does bulk fetch tickets at ​th:source:exceldownloadplugin/0.12/tracexceldownload/ticket.py@16204#L57.

Attachments (0)

Change History (2)

comment:1 by Ryan J Ollos, 5 years ago

Milestone: next-stable-1.2.x → next-stable-1.4.x

comment:2 by Ryan J Ollos, 2 years ago

Milestone: next-stable-1.4.x → next-stable-1.6.x

Milestone renamed

Modify Ticket

Change Properties
Set your email in Preferences
Action
as new The ticket will remain with no owner.
The ticket will be disowned.
as The resolution will be set. Next status will be 'closed'.
The owner will be changed from (none) to anonymous. Next status will be 'assigned'.

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