[Vtigercrm-developers] Input on optizing VT performance?
socialboostdk
socialboostdk at gmail.com
Wed Aug 3 07:57:02 GMT 2016
I fully agree that wrong index will cause big loss of speed.
Where do you see indexing problems in vt db?
Thanks!
Chris
On 3 August 2016 at 09:33, IT-Solutions4You <info at its4you.sk> wrote:
> > If you really looking into performance, hardware is the
> > final benchmark.
>
> 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
>
> Matus.
>
>
> Dňa 2. 8. 2016 o 19:02 Sutharsan Jeganathan napísal(a):
>
>> Hi Chris
>>
>> I would like to know whether HHVM is running at production environment
>> with vtiger 6.4 and almost all features are used? how much % of
>> performance it gives? If there is a significant improvement can be
>> achieved I would like to try it.
>>
>> In my experience, nginx gives little bit more than apache, but again
>> setup effort is needed.
>>
>> @socialboostdk : If you really looking into performance, hardware is the
>> final benchmark. From my experience, still vtiger struggles when
>> database size increases simaltaniously. Which could not be resolved
>> through front end optimization or backend optimization, but the
>> hardware. Even if the database size is static, performance could be
>> highly guaranteed by hardware only.
>>
>> Other question is, whether you need an overall performance, or to a
>> specific section, such as summary view? We did some solutions by
>> replacing summary view with single page concept with lazy loading which
>> provides a horizontal increase of page access time
>>
>>
>> Thanks
>> Sutharsan Jeganthan
>>
>> On Tue, Aug 2, 2016 at 6:27 PM, socialboostdk
>> <socialboostdk at gmail.com
>> <mailto:socialboostdk at gmail.com>> wrote:
>>
>> Hi Alan and Stefan,
>>
>> Thank you for very good input!
>>
>> My takeaway is then that I will look at updating libs + implementing
>> HHVM.
>>
>> Alan, for the js libs - is this integrated in v6.5? And/or can i
>> support your work here in a way where we can get it in future
>> versions so we dont have to do redundant work?
>>
>> Stefan - thank you very much, this sounds very interesting. I have a
>> good sysadmin, so i will ask him to look at it. Do you have
>> experience w. running VT on HHVM?
>>
>> Thanks for great input!
>>
>> Cheers,
>> Chris
>>
>> On 2 August 2016 at 14:22, Stefan Warnat <ich at stefanwarnat.de
>> <mailto:ich at stefanwarnat.de>> wrote:
>>
>> Hy Chris,
>>
>> This is not worth the time. (Sorry) ;) Because you will spend
>> too much time during analyse of code, which you could invest
>> better, because there already is a stable solution available.
>> Ask your Sysadmin to install HHVM from Facebook. This is much
>> fast then you reach with micro optimization.
>>
>> *AND*: This have a much better compatibility then PHP7 and also
>> runs with Vtiger < 6.5 with all modules. Only the setup is a
>> little bit tricky. But you get a 100% faster result within 2-3
>> hours.
>>
>> And I would use 6.5, because like Alan means, it is faster, too
>> and also runs with HHVM. I would not use PHP7 with Vtiger, now,
>> because you will get too much headaches.
>>
>> Stefan
>>
>>
>> ----
>> *Freelancer at Webdevelopment*
>>
>> Web: http://www.stefanwarnat.de
>> Xing: https://www.xing.com/profile/Stefan_Warnat2
>> LinkedIn: http://www.linkedin.com/pub/stefan-warnat/6/827/820
>> eMail: kontakt at stefanwarnat.de
>> <mailto:kontakt at stefanwarnat.de>
>>
>>
>> On Tue, Aug 2, 2016 at 1:45 PM, Alan Bell
>> <alan.bell at libertus.co.uk
>> <mailto:alan.bell at libertus.co.uk>> wrote:
>>
>>
>> On 02/08/16 12:34, socialboostdk wrote:
>>
>>> Hi there,
>>>
>>> I'm looking at optimizing the performance of VT, ie.
>>> compressing CSS, JS, etc. It also seems that there are
>>> many "overwrites" in the CSS where the same class is
>>> styled many times, etc.
>>>
>> JS/CSS optimising is mostly client side performance, which
>> frankly on modern PCs (or even phones/tables) isn't much of
>> an issue. I think the main thing to do with that is to get
>> all the javascript libraries updated from their sources and
>> organised in a way that means they can be easily updated in
>> future. This is something I started in this branch
>>
>> http://code.vtiger.com/alanbell/vtigercrm/tree/javascript_library_updates
>>
>>>
>>> Does anyone have any experience in doing this and/or
>>> pointers on where to begin to get "maximum efficiency" for
>>> optimal effort?
>>>
>> yes, use xdebug to profile what it does in PHP, where it
>> spends it's time rendering a page (prior to 6.5 it was
>> pretty much all in the to_html function, 6.5 is a lot faster)
>> You can make sure apache caches things correctly, and use an
>> opcode cache for a general php performance boost.
>> If you spot any improvements please contribute them to
>> code.vtiger.com <http://code.vtiger.com>
>>
>>>
>>> Ie. perhaps some obvious optimisations, etc.
>>>
>>> Thanks :)
>>>
>>> Best,
>>> Chris
>>>
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>>
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>>
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>>
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20160803/839622e7/attachment.html>
More information about the vtigercrm-developers
mailing list