[Vtigercrm-developers] vtigercrm-developers Digest, Vol 86, Issue 31

Adam Heinz amh at metricwise.net
Fri Mar 22 14:09:16 UTC 2013


We have been using a database cache with vtiger for a little over a year
now. Immediately after encapsulating user privileges (patch submitted as
Trac 7342 [1]), we replaced the user_privileges files on disk with an ADOdb
cache (patch submitted as Trac 7379 [2]).  The default cache is a file
cache, but you can easily configure memcache [3], or roll your own with the
caching API [4].

[1] http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7342
[2] http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7379
[3] http://phplens.com/lens/adodb/docs-adodb.htm#memcache
[4] http://phplens.com/lens/adodb/docs-adodb.htm#cacheapi



On Fri, Mar 22, 2013 at 12:13 AM, Prasad <prasad at vtiger.com> wrote:

> Adam,
>
> Can you share more details on the database cache you are referring to.
> Any specific changes you have tried / configured.
>
> Regards,
> Prasad
>
> *Connect with us on: *Twitter <http://twitter.com/vtigercrm> *I* Facebook<http://www.facebook.com/pages/vtiger/226866697333578?sk=wall>
>  *I* Blog <http://blog.vtiger.com/>* I* Wiki<http://wiki.vtiger.com/index.php/Main_Page>
>  *I *Forums  <http://forums.vtiger.com/>*I* Website <http://vtiger.com/>
>
>
> On Thu, Mar 21, 2013 at 7:35 PM, Adam Heinz <amh at metricwise.net> wrote:
>
>> I know the reason this feature is getting removed is performance, but
>> this is exactly the sort of thing that is easily avoided with a database
>> cache.
>>
>>
>>  On Thu, Mar 21, 2013 at 9:16 AM, Prasad <prasad at vtiger.com> wrote:
>>
>>>  Prabath,
>>>
>>> Can you please share the use-case and the values against which you have
>>> working with.
>>>
>>> Regards,
>>> Prasad
>>> *
>>> *
>>> *Connect with us on: *Twitter <http://twitter.com/vtigercrm> *I*
>>> Facebook <http://www.facebook.com/pages/vtiger/226866697333578?sk=wall>
>>> *I* Blog <http://blog.vtiger.com/>* I* Wiki<http://wiki.vtiger.com/index.php/Main_Page>
>>>  *I *Forums  <http://forums.vtiger.com/>*I* Website <http://vtiger.com/>
>>>
>>>
>>> On Thu, Mar 21, 2013 at 5:36 PM, Prabath Jayathilaka <
>>> jayathilaka at gmail.com> wrote:
>>>
>>>> this is very bad. I never agree with this. I'm currently working in a
>>>> bank project and that feature is  very very useful for me. so it is very
>>>> sad to hear about this. seems vtiger going to remove all the valuable
>>>> features.
>>>>
>>>> On Thu, Mar 21, 2013 at 5:30 PM, <
>>>> vtigercrm-developers-request at lists.vtigercrm.com> wrote:
>>>>
>>>>> Send vtigercrm-developers mailing list submissions to
>>>>>         vtigercrm-developers at lists.vtigercrm.com
>>>>>
>>>>> To subscribe or unsubscribe via the World Wide Web, visit
>>>>>
>>>>> http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers
>>>>>
>>>>> or, via email, send a message with subject or body 'help' to
>>>>>         vtigercrm-developers-request at lists.vtigercrm.com
>>>>>
>>>>> You can reach the person managing the list at
>>>>>         vtigercrm-developers-owner at lists.vtigercrm.com
>>>>>
>>>>> When replying, please edit your Subject line so it is more specific
>>>>> than "Re: Contents of vtigercrm-developers digest..."
>>>>>
>>>>>
>>>>> Today's Topics:
>>>>>
>>>>>    1. Re: A note on Role based picklists in vtiger6 (Alan Lord)
>>>>>    2. Re: A note on Role based picklists in vtiger6 (salim)
>>>>>
>>>>>
>>>>> ----------------------------------------------------------------------
>>>>>
>>>>> Message: 1
>>>>> Date: Thu, 21 Mar 2013 08:49:07 +0000
>>>>> From: Alan Lord <alanslists at gmail.com>
>>>>> To: vtigercrm-developers at lists.vtigercrm.com
>>>>> Subject: Re: [Vtigercrm-developers] A note on Role based picklists in
>>>>>         vtiger6
>>>>> Message-ID: <kiehhv$jlc$1 at ger.gmane.org>
>>>>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>>>>
>>>>> On 21/03/13 08:35, Vikas Jain wrote:
>>>>> > Hi,
>>>>> >
>>>>> > In Vtiger 6, we have dropped the support for role based picklists.
>>>>> This
>>>>> > feature was rarely used, but due to it, usability and performance
>>>>> > suffered (Alan's email "Performance Tweaking?" below discusses the
>>>>> > performance impact). As improving usability was the primary focus for
>>>>> > Vtiger6, this is one feature, which we felt had to go. Administrators
>>>>> > can still create and edit picklists but all choices in the picklists
>>>>> > will be visible to all members who have access to the field (field
>>>>> level
>>>>> > access is controlled via profile).
>>>>>
>>>>> Hi Vikas,
>>>>>
>>>>> I'm with you on this. +1
>>>>>
>>>>> Role-based picklists always *seemed* like a really nice feature, but I
>>>>> can't think of one customer that really uses it...
>>>>>
>>>>> The one issue I had with the change in 5.4.0 is the Picklist editor is
>>>>> a
>>>>> bit broken. (It works but the main page view doesn't show the picklist
>>>>> values, and the sequence column gets populated with picklist values so
>>>>> re-ordering doesn't really work. If I have time, it would be nice to
>>>>> have a patch for 5.4.0 that supports UIType 16 editing better but right
>>>>> now time is not something I have a great deal of.
>>>>>
>>>>> (That's a good thing BTW!)
>>>>>
>>>>> Cheers
>>>>>
>>>>> Al
>>>>>
>>>>> --
>>>>> Libertus Solutions
>>>>> http://www.libertus.co.uk
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ------------------------------
>>>>>
>>>>> Message: 2
>>>>> Date: Thu, 21 Mar 2013 14:55:33 +0530
>>>>> From: salim <salimcmd at gmail.com>
>>>>> To: vtigercrm-developers at lists.vtigercrm.com
>>>>> Subject: Re: [Vtigercrm-developers] A note on Role based picklists in
>>>>>         vtiger6
>>>>> Message-ID:
>>>>>         <CADQpn1b4Twi2pY+sZ9+e13Kony0jb=
>>>>> CcNDxayni6+sJ72bG+8Q at mail.gmail.com>
>>>>> Content-Type: text/plain; charset="iso-8859-1"
>>>>>
>>>>> Hi,
>>>>>     I think that was a nice feature, If someone using branch concept in
>>>>> vtiger , then that feature is very help full,  since they setting
>>>>> up branch based on role. So they can display pick list values based
>>>>> on branch's.
>>>>>
>>>>>
>>>>> Thanks
>>>>> --
>>>>> Salim
>>>>>
>>>>>
>>>>> On 21 March 2013 14:19, Alan Lord <alanslists at gmail.com> wrote:
>>>>>
>>>>> > On 21/03/13 08:35, Vikas Jain wrote:
>>>>> >
>>>>> >> Hi,
>>>>> >>
>>>>> >> In Vtiger 6, we have dropped the support for role based picklists.
>>>>> This
>>>>> >> feature was rarely used, but due to it, usability and performance
>>>>> >> suffered (Alan's email "Performance Tweaking?" below discusses the
>>>>> >> performance impact). As improving usability was the primary focus
>>>>> for
>>>>> >> Vtiger6, this is one feature, which we felt had to go.
>>>>> Administrators
>>>>> >> can still create and edit picklists but all choices in the picklists
>>>>> >> will be visible to all members who have access to the field (field
>>>>> level
>>>>> >> access is controlled via profile).
>>>>> >>
>>>>> >
>>>>> > Hi Vikas,
>>>>> >
>>>>> > I'm with you on this. +1
>>>>> >
>>>>> > Role-based picklists always *seemed* like a really nice feature, but
>>>>> I
>>>>> > can't think of one customer that really uses it...
>>>>> >
>>>>> > The one issue I had with the change in 5.4.0 is the Picklist editor
>>>>> is a
>>>>> > bit broken. (It works but the main page view doesn't show the
>>>>> picklist
>>>>> > values, and the sequence column gets populated with picklist values
>>>>> so
>>>>> > re-ordering doesn't really work. If I have time, it would be nice to
>>>>> have a
>>>>> > patch for 5.4.0 that supports UIType 16 editing better but right now
>>>>> time
>>>>> > is not something I have a great deal of.
>>>>> >
>>>>> > (That's a good thing BTW!)
>>>>> >
>>>>> > Cheers
>>>>> >
>>>>> > Al
>>>>> >
>>>>> > --
>>>>> > Libertus Solutions
>>>>> > http://www.libertus.co.uk
>>>>> >
>>>>> >
>>>>> > ______________________________**_________________
>>>>> > http://www.vtiger.com/
>>>>> >
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Muhammed Abdul Salim
>>>>> -------------- next part --------------
>>>>> An HTML attachment was scrubbed...
>>>>> URL: <
>>>>> http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20130321/85ad1119/attachment-0001.html
>>>>> >
>>>>>
>>>>> ------------------------------
>>>>>
>>>>> _______________________________________________
>>>>> vtigercrm-developers mailing list
>>>>> vtigercrm-developers at lists.vtigercrm.com
>>>>>
>>>>> http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers
>>>>>
>>>>>
>>>>> End of vtigercrm-developers Digest, Vol 86, Issue 31
>>>>> ****************************************************
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Best Regards
>>>>
>>>> K.M.D.P. Jayathilaka |Senior Software Engineer
>>>> Mobile: [+94] 714436981 | [+94]770797156
>>>> _______________________________________________
>>>> 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/20130322/d4d65582/attachment-0001.html>


More information about the vtigercrm-developers mailing list