Re: How to speed up loading of search page?

Hallo, Bernhard and list. I will be happy to create an issue for this,
but first I need to say that I don't think it's a PROBLEM with Roundup.
Instead, I think it's MY problem in not being able to rework the search
page slightly to retrieve a certain field more quickly.

The following line in issue.item.html, executes in about 1 second:

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

But the following in issue.search.html takes 4+ seconds:

<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>


Roundup: version 1.4.19
Database: Postgresql 9.1.7
OS: Linux bswf01 2.6.38-ARCH #1 SMP PREEMPT
Platform: Dual quad-core Xeon, 16GB RAM
Search: 
HTML templates are (probably) older

Danke vielmals, und
Cheers! 
-- 
David Hancock | [email protected]

-----Original Message-----

From: Bernhard Reiter <[email protected]>
Date: Wednesday, January 23, 2013 4:48 AM
To: <[email protected]>
Cc: David Hancock <[email protected]>
Subject: Re: [Roundup-users] How to speed up loading of search page?

>Hi David,
>
>Am Montag, 21. Januar 2013 17:00:36 schrieb Hancock, David (DHANCOCK):
>> I've had some user complaints about how slow the search page is to load.
>
>thanks for reporting a problem with roundup.
>I think it would be best to create an issue for it in our tracker (see
>the 
>webpage). The next step would be to make this reproducable easly,
>possibly by a test configuration or script or whatever that shows the
>issue.
>
>Also add which version of roundup you are using, platform, search engine
>and 
>database to the issues..
>
>> I'd be grateful for any ideas on how to speed this up? I'm a digest
>> subscriber, so the favor of copying [email protected] would be
>>appreciated
>> (but I'll check the archives, too).
>
>Best,
>Bernhard
>
>
>-- 
>www.intevation.de/~bernhard (CEO)    www.fsfe.org (Founding GA Member)
>Intevation GmbH, Osnabrück, DE; Amtsgericht Osnabrück, HRB 18998
>Geschäftsführer Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner


------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d