Details
-
Type:
Bug
-
Status: Won't Do
-
Priority:
Minor
-
Resolution: Won't Do
-
Affects Version/s: 4.3.3
-
Fix Version/s: Unscheduled
-
Component/s: None
-
Labels:None
-
Versioning Impact:Patch (backwards-compatible bug fixes)
Description
If you search for date added and the result is big (more than 10000 rows) the query ends in a internal server error (timeout in mysql).
I think the subquery in CRM_Contact_BAO_Query::dateQueryBuilder is responsible.
$addedDateQuery = 'select id from civicrm_log group by entity_id order by id';
Tested in WP Plugin (WP 3.5.2).
Please note related issue CRM-6903.
It looks like this has been improved. I can get results of 50k+ rows fairly quickly by using the 'added date' advanced search filter.
I'll close this off unless someone can recreate the issue.