Re: Too very slow pages on ic 5.10.0

Quoting Peter ([email protected]):
> On 11/03/18 01:44, marco wrote:
> > after 3 months of installation and light use my old production catalogue
> > with:
> 
> > I notice that for the pages with heavy query became very slow and
> > sometimes bring to "Gateway Timeout"
> > "top" utility display cpu to 100% during page wait sometimes for mysql
> > and sometimes for interchange
> 
> You need to benchmark the code on the problematic pages and find out
> exactly which lines or blocks of code are causing the issue.
> 
> This is most likely going to be the result of lots of DB hits from some
> very inefficient code.  Look for calls to [data] or [field], or similar
> tags that waste db hits inside of a [loop] or similar.  Rewrite your
> code so that it does a single query to the db to get all the data you
> need instead and it will end up being way more efficient.

Don't discount the possibility that the I/O on this virtual instance
is slower than on the other one. Are there demanding applications which
show the same speed on the new container? Try doing some large DB queries
on both the old and the new and comparing.

-- 
Mike Heins
phone +1.765.253.4194  <[email protected]>

The sun, with all those planets revolving around it and dependent on it,
can still ripen a bunch of grapes as if it had nothing else in the
universe to do. -- Galileo