Roundup Tracker - Issues

Message4768

Author dhancock@arinc.com
Recipients dhancock@arinc.com
Date 2013-01-23.18:22:18
Message-id <1358965339.4.0.483830445644.issue2550790@psf.upfronthosting.co.za>
In-reply-to
(not sure what Type rfe is, sorry).

We have a tracker with about 3,000 "custcomp" (customer company) entries and about 35,000 
issues overall. The issue.item.html for creating or modifying an issue loads in about 1 second, 
but the issue.search.html takes 9 seconds. Most of that time is in rendering the custcomp 
pulldown for searching.

I'd like to know how to either make this faster or replace the search retrieval with the item 
retrieval.

In issue.item.html, the following is the line of interest:

<td tal:content="structure context/custcomp/menu">custcomp</td>

And the corresponding section of issue.search.html is:

<tr tal:define="name string:custcomp;                                                                                   
                db_klass string:custcomp;                                                                               
                db_content string:name;">
  <th>Company:</th>
  <td metal:use-macro="search_select"></td>
  <td metal:use-macro="column_input"></td>
  <td metal:use-macro="sort_input"></td>
  <td metal:use-macro="group_input"></td>
</tr>

If I simply replace search_select line with the context/custcomp/menu line, the select list 
renders very fast, but of course then the search doesn't work.
History
Date User Action Args
2013-01-23 18:22:19dhancock@arinc.comsetrecipients: + dhancock@arinc.com
2013-01-23 18:22:19dhancock@arinc.comsetmessageid: <1358965339.4.0.483830445644.issue2550790@psf.upfronthosting.co.za>
2013-01-23 18:22:19dhancock@arinc.comlinkissue2550790 messages
2013-01-23 18:22:18dhancock@arinc.comcreate