<div dir="ltr"><div>Hi Ruben<br></div><div><br></div><div>Mostly it is hardware, because Vtiger is not an app developed on mongodb, it is MySQL :)<br></div><div><ol><li>From past experience 2GB RAM was not enough when crm_entity table arrives 1M. You may try 4GB</li><li>Is the disk SSD/M2? If not that can be one of the causes.<br></li><li>50 Users - I had issues starting when concurrent users increased above 20 which increases sessions, so might be proportion to RAM<br></li><li>Entire list view performance can be affected, if any of the user runs a un-filtered (or poorly filtered) Report</li><li>An archiving solution may help by moving unused leads out to archive . <br></li></ol><div>Modtracker? IMHO it won't affect list view.</div><div><br></div><div>Thanks</div><div>Sutharsan Jeganathan<br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Aug 4, 2020 at 12:34 AM Rubén A. Estrada Orozco <<a href="mailto:rulotec1@gmail.com">rulotec1@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi everyone,<div><br></div><div>I'm having a performance issue with one of my clients. vtiger takes too long to load listviews and sometimes 503 http errors are returned. Apparently the server has a great workload. Before increasing resources, I want to rule out there's something else that can be done.</div><div><ul><li>The server has a centos OS, 2GB RAM, 2 virtual CPUs, 2GB swap memory.</li><li>Vtgier version 7.1, PHP 7.0 fpm, Mariadb 5.5, apache 2.4.6</li><li>Aprox. 50 concurrent users</li><li>vtiger_crmentity table has 822 164 not deleted records and 23 380 deleted records (almost all of them are leads)</li></ul><div>Upon activating the slow queries log I see that the queries getting the listview of the leads module sometimes takes between 10 - 40 seconds with aprox 1million rows examined:</div></div><div><br></div><div><div><img src="cid:ii_kdev60cb0" alt="image.png" style="margin-right: 25px;"><br></div></div><div><br></div><div>Queries to the vtiger_modtracker table also take a while (36s in the example below with 3.3 million rows examined):</div><div><br></div><div><div><img src="cid:ii_kdev7hvn1" alt="image.png" style="margin-right: 0px;"><br></div></div><div><br></div><div>This is a resources consumption graph of the server from 8am to 2pm:</div><div><br></div><div><div><img src="cid:ii_kdevpd6a2" alt="image.png" width="562" height="526"><br></div></div><div>Any help will be appreciated.</div><div><br></div><div>Alan Lord, you previously commented that you have clientes with huge databases (several million rows). It would be really helpful to get some advice from you.</div><div><br></div><div>Thanks in advance<div><div dir="ltr"><div dir="ltr"><div>Rubén</div></div></div></div></div></div>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><font color="#9999ff"><i>Development Manager<br>
Radus28 Software Solution<br>
<img src="cid:part4.EAFD845F.485F57C8@radus28.com" title="www.radus28.com" alt="Radus28 Software Solution" width="205" height="60"><br>
123, Level 2, Mc Larens Building<br>
Baudhaloka Mw.<br>
Colombo 04<br>
Sri Lanka<br>
M : +94773795291<br>
E : <a href="mailto:sutharsan@radus28.com" target="_blank">sutharsan@radus28.com</a><br>
W : <a href="http://www.radus28.com" target="_blank">www.radus28.com</a></i></font></div></div>