[ic] Too very slow pages on ic 5.10.0

[marco]

Il 10/03/2018 22:11, David Christensen ha scritto:
>
>> On Mar 10, 2018, at 10:48 AM, Andrew Baerg <andrew at pullingshots.ca> wrote:
>>
>>> On 2018-03-10 05:44 AM, marco wrote:
>>>
>>> ---- (2) -----
>>> This now is a serious problem for me and my client and in the attempt to quickly solve it I try to install (develop server) interchange 5.6.3 on the new server debian 9 but there is a problem on make:
>>>
>>> root /usr/local/src/interchange-5.6.3 # make
>>> "/usr/bin/perl" "-Iblib/arch" "-Iblib/lib" relocate.pl scripts/ic_mod_perl
>>> Can't locate scripts/initp.pl in @INC (@INC contains: blib/arch blib/lib /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.24.1 /usr/local/share/perl/5.24.1 /usr/lib/x86_64-linux-gnu/perl5/5.24 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.24 /usr/share/perl/5.24 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base) at relocate.pl line 26.
>>> Makefile:898: recipe for target 'scripts/ic_mod_perl' failed
>>> make: *** [scripts/ic_mod_perl] Error 2
>>>
>>> Any suggestion ?
>>>
>>
>> I think you have missed running "perl Makefile.PL" before running make.
>
> I believe the issue here is perl 5.24 did away with including '.' as an implicit include path.  You would need to patch the IC 5.6 codebase to add '.' back into @INC or it won't be able to find the relative include.
>
> Best,
>
> David

Great David, is this !
Before compilation:
export PERL5LIB=.
And I can have standard and my old catalogs running.

Some warnings on run interchange daemon probably due to perl 5.24.1 or 
not yet analized catalog.cfg configuration:

---- (1) -----
Unescaped left brace in regex is deprecated, passed through in regex; 
marked by <-- HERE in m/(\$O{ <-- HERE (.*?)})/ at 
/usr/local/src/interchange-5.6.3/blib/lib/Vend/Ship.pm line 980, <DATA> 
line 1.

---- (2) -----
Global symbol "$table" requires explicit package name
...

---------- Test speed --------------
With ic 5.10.0 and debian 9 from "top" monitor I have displayed cpu 
activity for 2 heavy pages

a) a sheet of about 50 fields on 20 records (every pages) with a lot of 
query and in some cases take about 2 minutes or more of 100% cpu 
activity for mysql

b) the other is a more light sheet that engage interchange daemon to 
100% cpu for about 30 seconds

With ic 5.6.3 and debian 9
a) give about the same time,
b) is improved to 6 s.

With ic 5.6.3 and debian 6
a) run in 5-10 s,
b) 6 s

-- 
"Fino alla bara sinpara"
"Up to demise we rize"