restrict popup picker to limit

[Meyer]

Hi there

again i have over 3 mil contacts and if i choose the select 'popup picker' it takes very long for the search popup to appear. can this be sped up by letting the initial search only limit 10 until a search criteria is filled in, and /or only for modules /leads,emails?

Regards

paul

[ivolator]

Hi there

again i have over 3 mil contacts and if i choose the select 'popup picker' it takes very long for the search popup to appear. can this be sped up by letting the initial search only limit 10 until a search criteria is filled in, and /or only for modules /leads,emails?

Regards

paul

Hi Paul,
I would disable count query at first.

 $sugar_config['disable_count_query'] = true; 
  

[Meyer]

hi there

thanks, but where is the count query?

regards

Paul

[ivolator]

You just need to add this to your config override file
$sugar_config['disable_count_query'] = true;

[Meyer]

for some reason out of emails it works for the first select but not second. goes into an infiniate loop.

But its a start