[ic] Very slow [search-region] page

[Stefan Hornburg (Racke)]

On 09/14/2011 08:43 AM, marco wrote:
> Il 14/09/2011 08:24, Stefan Hornburg (Racke) ha scritto:
>> On 09/13/2011 09:33 PM, Sam Batschelet wrote:
>>>
>>> On Sep 13, 2011, at 12:03 PM, marco wrote:
>>>
>>>> An old page with minivend search become very slow. The query is from
>>>> only one mysql table products (159 fields and about 6000 records).
>>>>
>>>> The first result page 1..10 items is quick (3s):
>>>> url=cgi-bin/elcat/carr.html?mv_arg=&id=3nqtfXVE&anag=&tecn=&stor=&prez=1&stop=1
>>>>
>>>>
>>>> All the other subpages 11 .. 20, 21..30 etc etc are very slow (16s)
>>>> each:
>>>> url=cgi-bin/elcat/scan/MM=2a79e8aa45e82fb7361be8a2c995622a:10:19:10.html?mv_more_ip=1&mv_nextpage=carr&mv_arg=&id=3nqtfXVE&field_tf=&field_tf_val=&coord=&reverse=&order_to=&substring=&anag=&tecn=&stor=&prez=1&stop=1
>>>>
>>>>
>>>> If i put 60 items for page i get "Internal Server Error", the
>>>> error.log of interchange say:elcat - hammered pid 12644 running 300
>>>> seconds
>>>> and without errors on catalogue error.log
>>>
>>> Not sure on the query load time but check out Jobs MaxLifetime located
>>> in your interchange.cfg file. Increasing this value will allow the
>>> query to run for a longer time.
>>>
>>> http://www.icdevgroup.org/docs/confs/Jobs.html
>>
>> Jobs MaxLifetime is only for Interchange jobs (e.g. run by interchange
>> --runjobs=...). PIDcheck is for normal Interchange requests,
>> but I doubt that users are patient enough to wait for that long.
>>
>> Marco, please post the body of your search-region to give us a better
>> chance to help you with this problem.
>>
>> Regards
>> Racke
>>
>
> Ok :-)
>
> [if !scratch port_search]
> [search-region more=1
> search="
> st=db
> ml=[scratch per_pag]
> [if cgi coord]
> co=yes
> sf=[scratch field_tf]
> se=[cgi field_tf_val]
> [else]
> co=no
> [/else]
> [/if]
> [if cgi substring eq 'yes']
> su=yes
> [/if]
> os=1
> sf=elcar
> se=S
> os=1
> sf=ELC_CODICE_CT
> se=VFS
>
> tf=[scratch field_tf] [if scratch field_tf],[/if] [if scratch field_tf eq 'ELC_CODICE_CLI']ELC_NOTE_DES ,[/if] ELC_PORTATA:rn ,ELC_ANNO:rn
> to=[scratch reverse][scratch order_to]
> "]
> [else]
> [search-region more=1
> search="
> st=db
> ml=[scratch per_pag]
> co=yes
>
> sf=ELC_PORTATA
> se=[scratch min]
> op=ge
> nu=1
> ne=no
>
> sf=ELC_PORTATA
> se=[scratch max]
> op=le
> nu=1
> ne=no
>
> os=1
> sf=elcar
> se=S
> os=1
> sf=ELC_CODICE_CT
> se=VFS
>
> tf=ELC_PORTATA:rn ,ELC_ANNO:rn
> "]
> [/else][/if]
>
> [link-template]<a href="$URL$&id=[data session id]&field_tf=[cgi field_tf]&field_tf_val=[cgi field_tf_val]&coord=[cgi coord]&reverse=[cgi reverse]&order_to=[cgi order_to]&substring=[cgi substring]&anag=[cgi anag]&tecn=[cgi tecn]&stor=[cgi stor]&prez=[cgi prez]&stop=1">$ANCHOR$</a>[/link-template]
>

Sorry, that's not the body I'm looking for. Please show all the ITL with [item-...] etc.

Regards
	Racke

-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team