[ic] Performance Issue
Stefan Hornburg (Racke)
racke at linuxia.de
Thu Feb 15 03:47:38 EST 2007
Lars Tode wrote:
> Hi list.
> Few days ago I ported a catalog from Interchange 5.2.1 to 5.4.2 (and
> from one server to newer one). Since then I had massive problems with
> the performance of loops.
> The SQL - Statements are really fast, less then one second (in the sql -
> shell and in interchange). While debugging the code
> (Vend::Interpolate::query) I saw the the first form of the page
> (contains the products and some usertags and variables) was generated
> really fast. Everything after that (replace the usertags, scratches, if
> ...) took too much time (38 Seconds minimum).
> I think the problem is located caused by the changes of
> Vend::Interpolate (it changed from version 18.104.22.168 to version
> 2.261.2.5), becaue the same code works fast in the old catalog.
> The new server is a quadcore, raid 10. The cpu load of interchange,
> while process the loop, is round about 98 %.
> I installed the old interchange (5.2.1) on this server to and did the
> same reques. The response of the old server is much more faster (cpu
> load 26 %).
> Any ideas?
Show your looping codes.
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