<div dir="ltr">Hy,<div><br></div><div>To HHVM:</div><div><b>The most important one at first</b>: Every feature of Vtiger/PDFMaker/EmailMaker works! I never found one function I cannot use. And I/we use it in production for a huge client, which would directly complain about a problem.</div><div>Facebook take a look to be more compatibly a little bit. (Not generally all PHP is compatible, but nothing within vtiger)</div><div><br></div><div>Maybe you don't trust my benchmark and I couldn't believe it myself. Maybe in production environment I had some special MySQL Improvements. </div><div><br></div><div>But in production I use mysql replication, which gave a very little decreased performance.</div><div>I have two similar systems with ~200 000 Records in crmentity. (I must say VtigerCRM 6.2)</div><div><br></div><div>1 Testing system - On PHP 5.6:</div><div>1 Open the Invoice overview with 30 records and the loading time is ~1.5 sec.</div><div><br></div><div>1 Production - On HHVM:</div><div>I open the Overview of Invoices with 50 Records and the loading time is 475ms.</div><div><br></div><div>An explanation could be, like Alan means, Vtiger heavily works inside to_html function. HHVM extremely optimize often used functions.</div><div>But I never try to figure out, why it is so fast.</div><div><br></div><div><br></div><div>Stefan</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><br><span style="font-size:x-small">--</span><span style="font-size:x-small">--</span><br><b><font size="1">Freelancer@Webdevelopment</font></b><br><br><font size="1">Web: </font><a href="http://www.stefanwarnat.de" style="font-size:x-small" target="_blank">http://www.stefanwarnat.de</a><br><font size="1">Xing: </font><a href="https://www.xing.com/profile/Stefan_Warnat2" style="font-size:x-small" target="_blank">https://www.xing.com/profile/Stefan_Warnat2</a><br><font size="1">LinkedIn: </font><a href="http://www.linkedin.com/pub/stefan-warnat/6/827/820" style="font-size:x-small" target="_blank">http://www.linkedin.com/pub/stefan-warnat/6/827/820</a><br><font size="1">eMail: <a href="mailto:kontakt@stefanwarnat.de" target="_blank">kontakt@stefanwarnat.de</a></font><br><br></div></div></div>
<br><div class="gmail_quote">On Wed, Aug 3, 2016 at 10:37 AM, IT-Solutions4You <span dir="ltr"><<a href="mailto:info@its4you.sk" target="_blank">info@its4you.sk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I mean not wrong indexes but missing indexes in vtiger, like at all cf tables no index at id field and from this reason each JOIN <a href="http://acount.id" rel="noreferrer" target="_blank">acount.id</a> = vtiger_accountscf.accountid take more time. Second bigg point si that NO fields like invoice_no is not indexed and I suppose you search for invoice no very often.<br>
<br>
This old forge project can be start point <a href="http://forge.vtiger.com/projects/vtsql-opt/" rel="noreferrer" target="_blank">http://forge.vtiger.com/projects/vtsql-opt/</a>. It's for 5.4 version I don't know if there is any implementation in vtiger 6.x<br>
<br>
Matus<br>
<br>
Dňa 3. 8. 2016 o 9:57 socialboostdk napísal(a):<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
I fully agree that wrong index will cause big loss of speed.<br>
<br>
Where do you see indexing problems in vt db?<br>
<br>
Thanks!<br>
Chris<br>
<br>
On 3 August 2016 at 09:33, IT-Solutions4You<br>
<<a href="mailto:info@its4you.sk" target="_blank">info@its4you.sk</a><br></span><div><div class="h5">
<mailto:<a href="mailto:info@its4you.sk" target="_blank">info@its4you.sk</a>>> wrote:<br>
<br>
> If you really looking into performance, hardware is the<br>
> final benchmark.<br>
<br>
I'm sorry but I disagree with this opinion. Right index DB setting<br>
increase the speed of the system without hardware changes. And<br>
vtiger need better indexes at all<br>
<br>
Matus.<br>
<br>
<br>
Dňa 2. 8. 2016 o 19:02 Sutharsan Jeganathan napísal(a):<br>
<br>
Hi Chris<br>
<br>
I would like to know whether HHVM is running at production<br>
environment<br>
with vtiger 6.4 and almost all features are used? how much % of<br>
performance it gives? If there is a significant improvement can be<br>
achieved I would like to try it.<br>
<br>
In my experience, nginx gives little bit more than apache, but again<br>
setup effort is needed.<br>
<br>
@socialboostdk : If you really looking into performance,<br>
hardware is the<br>
final benchmark. From my experience, still vtiger struggles when<br>
database size increases simaltaniously. Which could not be resolved<br>
through front end optimization or backend optimization, but the<br>
hardware. Even if the database size is static, performance could be<br>
highly guaranteed by hardware only.<br>
<br>
Other question is, whether you need an overall performance, or to a<br>
specific section, such as summary view? We did some solutions by<br>
replacing summary view with single page concept with lazy<br>
loading which<br>
provides a horizontal increase of page access time<br>
<br>
<br>
Thanks<br>
Sutharsan Jeganthan<br>
<br>
On Tue, Aug 2, 2016 at 6:27 PM, socialboostdk<br>
<<a href="mailto:socialboostdk@gmail.com" target="_blank">socialboostdk@gmail.com</a><br>
<mailto:<a href="mailto:socialboostdk@gmail.com" target="_blank">socialboostdk@gmail.com</a>><br></div></div>
<mailto:<a href="mailto:socialboostdk@gmail.com" target="_blank">socialboostdk@gmail.com</a><span class=""><br>
<mailto:<a href="mailto:socialboostdk@gmail.com" target="_blank">socialboostdk@gmail.com</a>>>><br>
wrote:<br>
<br>
Hi Alan and Stefan,<br>
<br>
Thank you for very good input!<br>
<br>
My takeaway is then that I will look at updating libs +<br>
implementing<br>
HHVM.<br>
<br>
Alan, for the js libs - is this integrated in v6.5? And/or can i<br>
support your work here in a way where we can get it in future<br>
versions so we dont have to do redundant work?<br>
<br>
Stefan - thank you very much, this sounds very interesting.<br>
I have a<br>
good sysadmin, so i will ask him to look at it. Do you have<br>
experience w. running VT on HHVM?<br>
<br>
Thanks for great input!<br>
<br>
Cheers,<br>
Chris<br>
<br>
On 2 August 2016 at 14:22, Stefan Warnat<br>
<<a href="mailto:ich@stefanwarnat.de" target="_blank">ich@stefanwarnat.de</a><br>
<mailto:<a href="mailto:ich@stefanwarnat.de" target="_blank">ich@stefanwarnat.de</a>><br></span>
<mailto:<a href="mailto:ich@stefanwarnat.de" target="_blank">ich@stefanwarnat.de</a><div><div class="h5"><br>
<mailto:<a href="mailto:ich@stefanwarnat.de" target="_blank">ich@stefanwarnat.de</a>>>> wrote:<br>
<br>
Hy Chris,<br>
<br>
This is not worth the time. (Sorry) ;) Because you will<br>
spend<br>
too much time during analyse of code, which you could invest<br>
better, because there already is a stable solution<br>
available.<br>
Ask your Sysadmin to install HHVM from Facebook. This is<br>
much<br>
fast then you reach with micro optimization.<br>
<br>
*AND*: This have a much better compatibility then PHP7<br>
and also<br>
runs with Vtiger < 6.5 with all modules. Only the setup is a<br>
little bit tricky. But you get a 100% faster result<br>
within 2-3<br>
hours.<br>
<br>
And I would use 6.5, because like Alan means, it is<br>
faster, too<br>
and also runs with HHVM. I would not use PHP7 with<br>
Vtiger, now,<br>
because you will get too much headaches.<br>
<br>
Stefan<br>
<br>
<br>
----<br>
*Freelancer@Webdevelopment*<br>
<br>
Web: <a href="http://www.stefanwarnat.de" rel="noreferrer" target="_blank">http://www.stefanwarnat.de</a><br>
Xing: <a href="https://www.xing.com/profile/Stefan_Warnat2" rel="noreferrer" target="_blank">https://www.xing.com/profile/Stefan_Warnat2</a><br>
LinkedIn:<br>
<a href="http://www.linkedin.com/pub/stefan-warnat/6/827/820" rel="noreferrer" target="_blank">http://www.linkedin.com/pub/stefan-warnat/6/827/820</a><br>
eMail: <a href="mailto:kontakt@stefanwarnat.de" target="_blank">kontakt@stefanwarnat.de</a><br>
<mailto:<a href="mailto:kontakt@stefanwarnat.de" target="_blank">kontakt@stefanwarnat.de</a>><br></div></div>
<mailto:<a href="mailto:kontakt@stefanwarnat.de" target="_blank">kontakt@stefanwarnat.de</a><span class=""><br>
<mailto:<a href="mailto:kontakt@stefanwarnat.de" target="_blank">kontakt@stefanwarnat.de</a>>><br>
<br>
<br>
On Tue, Aug 2, 2016 at 1:45 PM, Alan Bell<br>
<<a href="mailto:alan.bell@libertus.co.uk" target="_blank">alan.bell@libertus.co.uk</a><br>
<mailto:<a href="mailto:alan.bell@libertus.co.uk" target="_blank">alan.bell@libertus.co.uk</a>><br>
<br></span>
<mailto:<a href="mailto:alan.bell@libertus.co.uk" target="_blank">alan.bell@libertus.co.uk</a><div><div class="h5"><br>
<mailto:<a href="mailto:alan.bell@libertus.co.uk" target="_blank">alan.bell@libertus.co.uk</a>>>> wrote:<br>
<br>
<br>
On 02/08/16 12:34, socialboostdk wrote:<br>
<br>
Hi there,<br>
<br>
I'm looking at optimizing the performance of VT, ie.<br>
compressing CSS, JS, etc. It also seems that<br>
there are<br>
many "overwrites" in the CSS where the same class is<br>
styled many times, etc.<br>
<br>
JS/CSS optimising is mostly client side performance,<br>
which<br>
frankly on modern PCs (or even phones/tables) isn't<br>
much of<br>
an issue. I think the main thing to do with that is<br>
to get<br>
all the javascript libraries updated from their<br>
sources and<br>
organised in a way that means they can be easily<br>
updated in<br>
future. This is something I started in this branch<br>
<br>
<a href="http://code.vtiger.com/alanbell/vtigercrm/tree/javascript_library_updates" rel="noreferrer" target="_blank">http://code.vtiger.com/alanbell/vtigercrm/tree/javascript_library_updates</a><br>
<br>
<br>
Does anyone have any experience in doing this and/or<br>
pointers on where to begin to get "maximum<br>
efficiency" for<br>
optimal effort?<br>
<br>
yes, use xdebug to profile what it does in PHP, where it<br>
spends it's time rendering a page (prior to 6.5 it was<br>
pretty much all in the to_html function, 6.5 is a<br>
lot faster)<br>
You can make sure apache caches things correctly,<br>
and use an<br>
opcode cache for a general php performance boost.<br>
If you spot any improvements please contribute them to<br>
<a href="http://code.vtiger.com" rel="noreferrer" target="_blank">code.vtiger.com</a> <<a href="http://code.vtiger.com" rel="noreferrer" target="_blank">http://code.vtiger.com</a>><br>
<<a href="http://code.vtiger.com" rel="noreferrer" target="_blank">http://code.vtiger.com</a>><br>
<br>
<br>
Ie. perhaps some obvious optimisations, etc.<br>
<br>
Thanks :)<br>
<br>
Best,<br>
Chris<br>
<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
<br>
<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
<br>
<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
<br>
<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
<br>
<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
<br>
</div></div></blockquote>
<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote></div><br></div>