[ic] Very slow [search-region] page
marco
m.mescoli at omnib.it
Tue Sep 13 16:03:01 UTC 2011
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
Interchange: 5.6.2
MySql: 5.0.51a
Perl: v5.8.8 built for i486-linux-gnu-thread-multi
Any suggestion ?
Substitution of [search-region] with sql [query] can solve ?
Thanks in advance.
--
Marco "Fino alla bara sinpara"
Marco "Up to demise we rise"
More information about the interchange-users
mailing list