[Vtigercrm-developers] calendar optimization

[Prasad]

Adam,

Interesting - can you share the details of changes that is required for
based on Vtiger 6 Beta.

Regards,
Prasad

*Connect with us on: *Twitter <http://twitter.com/vtigercrm> *I*
Facebook<http://www.facebook.com/pages/vtiger/226866697333578?sk=wall>
 *I* Blog <https://blogs.vtiger.com/>* I*
Wiki<http://wiki.vtiger.com/index.php/Main_Page>
 *I *Forums  <https://discussions.vtiger.com>*I*
Website<https://www.vtiger.com/>


On Wed, Aug 14, 2013 at 1:44 AM, Adam Heinz <amh at metricwise.net> wrote:

> We do a ton of scheduling here, so our calendars get hammered all the
> time.  Some of our larger stores are starting to see performance problems
> due to various calendar queries running full index scans.  The most
> prevalent examples are readAppointment [1][2] and getEventList [3].  Due to
> all the OR conjunctions in the WHERE clauses, MySQL is unable to determine
> a useful index, even after I've removed all of the CAST/CONCAT calls.  Is
> anyone else having performance problems with their calendar?  I have some
> fairly drastic ideas on how to solve the problem.  ;)
>
> [1]
> http://trac.vtiger.com/cgi-bin/trac.cgi/browser/vtigercrm/branches/5.4.0/modules/Calendar/Appointment.php#L61
> [2]
> http://trac.vtiger.com/cgi-bin/trac.cgi/browser/vtigercrm/branches/6.0.0/modules/Calendar/Appointment.php#L61
> [3]
> http://trac.vtiger.com/cgi-bin/trac.cgi/browser/vtigercrm/branches/5.4.0/modules/Calendar/calendarLayout.php#L1357
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20130814/a5fc4def/attachment-0001.html>