Results 1 to 3 of 3

Thread: Performance problem with 4.2.1b

  1. #1
    Proware's Avatar
    Proware is offline A Prolific Poster
    Join Date
    Mar 2006
    Location
    Sydney Australia
    Posts
    310

    Default Performance problem with 4.2.1b

    The disable_count_query' => true config option works fine for list views but why has it not been applied to detail views?

    I want the VCR controls, just dont need the record count!

    Just show the current record number - it will be much faster.
    Cheers

    David Younger
    TSM - The Service Manager
    http://www.theservicemanager.com


    Operating system type and version: Windows 2003 Server
    » Sugar Suite version 4.5.1e Professional
    » Webserver type and version Microsoft-IIS/6.0
    » PHP version 5.2.6
    » MySQL server version 5.0.51a

  2. #2
    jmaxwell is offline Sugar Community Member
    Join Date
    Jul 2005
    Posts
    51

    Default Re: Performance problem with 4.2.1b

    Turning off the vcr controls is the best choice. Leaving them engaged in any manner (even without the count query) still requires a listview query to be done on the detail view page. That's the big time-suck. By eliminating that, you get much faster performance on the detail views. I am not sure if it would be possible to have any sort of vcr controls on a detail page without passing in some sort of listview array/object also. Probably not... (at least not w/o rewriting large pieces of code). you could write a separate function that passed in an array of just the ID's for whatever records you are viewing, and then step through those with vcr controls... that would save some of the overhead of the (HUGE) listview object that gets passed around otherwise.

    -Ed

  3. #3
    Proware's Avatar
    Proware is offline A Prolific Poster
    Join Date
    Mar 2006
    Location
    Sydney Australia
    Posts
    310

    Default Re: Performance problem with 4.2.1b

    That is exactly what we did with our TSM software and it works well.

    Functionally, the VCR is in fact heavily used by us.
    Cheers

    David Younger
    TSM - The Service Manager
    http://www.theservicemanager.com


    Operating system type and version: Windows 2003 Server
    » Sugar Suite version 4.5.1e Professional
    » Webserver type and version Microsoft-IIS/6.0
    » PHP version 5.2.6
    » MySQL server version 5.0.51a

Thread Information

Users Browsing this Thread

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

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
  •