[ic] Very slow [search-region] page

Stefan Hornburg (Racke) racke at linuxia.de
Wed Sep 14 06:24:20 UTC 2011

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.


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

More information about the interchange-users mailing list