<div dir="ltr"><div>I fully agree that wrong index will cause big loss of speed. <br></div><div><br></div><div>Where do you see indexing problems in vt db?</div><div><br></div><div>Thanks!</div><div>Chris</div><div class="gmail_extra"><br><div class="gmail_quote">On 3 August 2016 at 09:33, 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"><span class="">> If you really looking into performance, hardware is the<br>
> final benchmark.<br>
<br></span>
I'm sorry but I disagree with this opinion. Right index DB setting increase the speed of the system without hardware changes. And 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>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
Hi Chris<br>
<br>
I would like to know whether HHVM is running at production 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, 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 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></span><span class="">
<mailto:<a href="mailto:socialboostdk@gmail.com" target="_blank">socialboostdk@gmail.com</a>>> 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 + 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. 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 <<a href="mailto:ich@stefanwarnat.de" target="_blank">ich@stefanwarnat.de</a><br></span><span class="">
<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 spend<br>
too much time during analyse of code, which you could invest<br>
better, because there already is a stable solution available.<br>
Ask your Sysadmin to install HHVM from Facebook. This is much<br>
fast then you reach with micro optimization.<br>
<br></span>
*AND*: This have a much better compatibility then PHP7 and also<span class=""><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 within 2-3<br>
hours.<br>
<br>
And I would use 6.5, because like Alan means, it is faster, too<br>
and also runs with HHVM. I would not use PHP7 with Vtiger, now,<br>
because you will get too much headaches.<br>
<br>
Stefan<br>
<br>
<br>
----<br></span>
*Freelancer@Webdevelopment*<span class=""><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: <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></span>
<mailto:<a href="mailto:kontakt@stefanwarnat.de" target="_blank">kontakt@stefanwarnat.de</a>><span class=""><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></span><span class="">
<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>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi there,<br>
<br>
I'm looking at optimizing the performance of VT, ie.<br>
compressing CSS, JS, etc. It also seems that there are<br>
many "overwrites" in the CSS where the same class is<br>
styled many times, etc.<br>
</blockquote>
JS/CSS optimising is mostly client side performance, which<br>
frankly on modern PCs (or even phones/tables) isn't much of<br>
an issue. I think the main thing to do with that is to get<br>
all the javascript libraries updated from their sources and<br>
organised in a way that means they can be easily updated in<br>
future. This is something I started in this branch<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>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Does anyone have any experience in doing this and/or<br>
pointers on where to begin to get "maximum efficiency" for<br>
optimal effort?<br>
</blockquote>
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 lot faster)<br>
You can make sure apache caches things correctly, and use an<br>
opcode cache for a general php performance boost.<br>
If you spot any improvements please contribute them to<br></span>
<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>><span class=""><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<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>
</blockquote>
<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>
</span></blockquote>
<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote></div><br></div></div>