[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):
>> All the other subpages 11 .. 20, 21..30 etc etc are very slow (16s) each:
>> 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.
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