Error: Query limit of 1000 reached

[Veritascredit]

One of my sales associates gets the errors in his ECalender module when he selects month view, this does not happen in Day or week view. I contacted Lithrium, the developers of Ecalendar and they let me know that this error is not a bug but a limitation set inside Sugar.

"Error: Query limit of 1000 reached for ECalendar module."

1st- i'm wondering if we are doing something wrong, or is it that we have actually hit the limit of the Query search.

My sales associate definitely does not have 1000 task,meetings. calls within the a months time table, set up (I'm not sure though if these are the only search fields for the "Query" search though either.)

2nd - if ultimately we are doing everything right and we have hit the limit, what would be the best practice so that my sales associate can actually view his monthly schedule at and avoid getting the error message.

Thank you for everyone's contribution!

Glen

[kuske]

1 - take it as it is, mysql sometime calculates more then 1000 result record even if there are only 100

2- look to config.php, there is an entry like that:

'resource_management' =>
array (
'special_query_limit' => 50000,
'special_query_modules' =>
array (
0 => 'Reports',
1 => 'Export',
2 => 'Import',
3 => 'Administration',
4 => 'Sync',
),
'default_limit' => 1000,
),

Just add your module in the list of special_query_modules.

[Veritascredit]

Herald,

Thank you very much, this worked like a charm!

Much appreciated as always.

Glen

[christianknoll]

Harald,

(2) is right but with (1) you are wrong. This is the number of queries SugarCRM submits in one roundtrip (not the number of rows returned) ... amazing that this exceeds the number but as I figured out one of the problem is the dup check in some areas ...

christian.

1 - take it as it is, mysql sometime calculates more then 1000 result record even if there are only 100

2- look to config.php, there is an entry like that:

'resource_management' =>
array (
'special_query_limit' => 50000,
'special_query_modules' =>
array (
0 => 'Reports',
1 => 'Export',
2 => 'Import',
3 => 'Administration',
4 => 'Sync',
),
'default_limit' => 1000,
),

Just add your module in the list of special_query_modules.

[kuske]

Oh yes Christian you are right.

I think the correct number of queries is something like
q = x + n * y
where n is the number of resulted lines.

So the complexity value is something like O(n).

The problem is, that the y in the above fomula depends on the current implementation. That means that it can change if you add some relations or change a listview or what else...