Results 1 to 7 of 7

Thread: Performance tuning tip for speeding up calendar updates

  1. #1
    clint's Avatar
    clint is offline SugarCRM CTO & Co-founder
    Join Date
    Aug 2004
    Location
    Silicon Valley
    Posts
    2,122

    Default Performance tuning tip for speeding up calendar updates

    If you have followed the Performance Tweaks for Large Systems article in the Sugar Wiki, you will know that updating the Free/Busy calendar information that is stored in Sugar can be a resource intensive task if you have a lot of meetings and calls stored in your Sugar system.

    As of Sugar 5.2.0 patch C, we have added the ability to turn off updates to the Free/Busy information with a new System Settings switch. You will only need the Free/Busy information to be kept up-to-date if your company is using Sugar to store Free/Busy information for use with the MS Outlook calendar.

    Learn more about this in the
    New vCal Updates Setting in 5.2.0c Developer Blog post.
    Sugar Developer Zone - developer resources | Sugar University - user and admin training
    Sugar Docs - user and admin documentation |
    Sugar Bug Tracker - Enter or view bugs
    SugarForge- open source modules, themes, lang packs | SugarExchange - commercial extensions

    Clint Oram
    Chief Technology Officer and Co-founder
    SugarCRM

  2. #2
    crmsiva's Avatar
    crmsiva is offline A Sugar Hero
    Join Date
    Jan 2009
    Location
    Chennai, India
    Posts
    1,128

    Default Re: Performance tuning tip for speeding up calendar updates

    Thanks for the info. "vCal Updates Time Period" option is really useful one.

  3. #3
    jjwdesign is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Orlando, FL
    Posts
    556

    Default Re: Performance tuning tip for speeding up calendar updates

    Clint, thanks for the update notice. I never really thought about calendar information. I've always focused on Server and Database configuration.
    SugarForge Projects:
    JJWDesign Google Maps
    JJWDesign Import Tools

    Follow my blog postings at JJW Design.

  4. #4
    nsteindorf is offline Member
    Join Date
    Jul 2009
    Posts
    6

    Default Re: Performance tuning tip for speeding up calendar updates

    Hi,

    i have been playing around with the scheduling of meetings (within Sugar) and noticed, that vCal is used to show wheter an attendee is available or not (free/busy). Very helpful to prevent overlapping of meetings.

    Now: if i turn off the Free/Busy information via System switch, will this effect the scheduling of meetings within Sugar as well? Because you stated, that this will only be used for external scheduling (MS Outlook, etc.).

    Thanks!

    Nils

  5. #5
    hdanielb's Avatar
    hdanielb is offline Sugar Community Member
    Join Date
    Oct 2009
    Location
    Argentina & Chile
    Posts
    61

    Default Re: Performance tuning tip for speeding up calendar updates

    Thanks for this... I am making all possible efforts to make SugarCRM speed up!
    Daniel Blanco
    Director
    Blanco Martin & Asociados
    Worldwide Hosted Software Solutions

    Visit us at www.blancomartin.com.ar

    Now at Chile:
    Apoquindo 6410 Of 212
    Phone +5628400990

    Las Condes
    Santiago, Chile

    www.blancomartin.cl

  6. #6
    krishsugar is offline Sugar Community Member
    Join Date
    Apr 2007
    Posts
    13

    Default Re: Performance tuning tip for speeding up calendar updates

    On every page on the footer, Sugar displays the "Server Response Time". I would like to log this information using the logger, so that I can analyze the performance over a long time period and on the time of the day. I tried modifying the index.php, where it is calculating the delta time, and added the log message.

    Noticed every request is not reaching this place, it works for list page but not for the details page. On the otherhand Sugar is able to show the server response time on every page. Apart from index.php. is there any other place where this delta time is getting calculated.

    Thanks
    Gopal

  7. #7
    glyquiroz is offline Member
    Join Date
    Mar 2009
    Posts
    11

    Default Re: Performance tuning tip for speeding up calendar updates

    Hi,

    I'm using Sugar 5.2 with SQL Server 2005 and the performance after a year has dropped significantly.
    I tried the "Performance Tweaks for Large Systems",but not difference whatsoever, also, just as a test I changed the ID for my user in the users table and of course as a "new user" the performance was flawless, I tried reducing tracker table to only last month transactions, but not improvment there. I'm not sure which query is the "trouble query", since performance is different for different users. I turned on the slow query but nothing shows there...
    Thanks for any help.

    GQ

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. where is mysql fine tuning document??
    By sankar in forum Developer Help
    Replies: 1
    Last Post: 2007-05-23, 03:49 PM
  2. calendar updates with AJAX
    By sugarcare in forum Feature Requests
    Replies: 0
    Last Post: 2006-11-13, 06:06 PM
  3. Speeding up Sugar 4.0
    By dickb in forum General Discussion
    Replies: 49
    Last Post: 2006-10-01, 06:08 AM
  4. Dashboard graphics, Calendar updates
    By fastbob in forum Help
    Replies: 1
    Last Post: 2006-09-25, 03:53 PM
  5. 3.51 / 4.01 Calendar slow performance
    By dkmeans in forum Help
    Replies: 1
    Last Post: 2006-02-08, 10:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •