[Vtigercrm-developers] default sort orders

[Uma S]

Hi,

Thanks for having a look at optimization. I have created trac
<http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8269> for same. Will look
into this soon.

On Wed, Sep 24, 2014 at 6:27 PM, Alan Bell <alan.bell at libertus.co.uk> wrote:

> it would appear that the value LISTVIEW_DEFAULT_SORTING in
> performance.inc.php doesn't do much at the moment, it should set default
> list view sorting to be something sensible for each entity module. Whatever
> it is set to at the moment things sort by default on modified time DESC,
> which in some cases is a rather bad thing to do and can cause slow queries.
> I think to fix it the file modules/Vtiger/models/ListView.php around line
> 188 should be:
>
>                 if(empty($orderBy) && empty($sortOrder) && $moduleName !=
> "Users"){
> if(PerformancePrefs::getBoolean('LISTVIEW_DEFAULT_SORTING', true)) {
>                                 $orderBy = $moduleFocus->default_order_by;
>                                 $sortOrder = $moduleFocus->default_sort_
> order;
>                         }
>                 }
>
> so that if a sort order isn't specified in the request it should use the
> default sort order for the module rather than modifiedtime desc, and no
> particular order if default sorting is turned off. No particular order is
> faster than sorting by modified time, especially on contacts it would seem.
>
> Alan.
>
> --
> Libertus Solutions
> http://libertus.co.uk
>
> _______________________________________________
> http://www.vtiger.com/
>



-- 
With
Best Regards
Uma.S
Vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140926/c9942a76/attachment.html>