Author Topic: complex search - mysql gets stuck (Read 573 times)

julianbrelsford · September 03, 2010, 12:33:31 pm

I attempted to run a complex query in civicrm: searching for several "smart groups" (between 7 and 20). The search should return between 300 and 3000 people. "top" indicates that the mysql process is using 100% of one cpu core, but there is no visible progress in my web browser after 15+ minutes.

essentially, we want to search for all the members & other participants at several congregations in our religious organization.

at less than 3000 records, this is not a particularly huge data set, so I'm not sure why the machine completely fails to return search results. anybody know how to fix this problem?

petednz · September 03, 2010, 02:52:57 pm

It isn't the size of the dataset as the complexity of the query - if you are trying to grab lots of Smart Groups in one go then that may be your issue - can't you grab them in smaller clumps - note that some queries can (or used to) keep running in the background even if you kill your Search screen - so you may be creating a log jam out of sight

CiviCRM Community Forums (archive)

News:

Author Topic: complex search - mysql gets stuck (Read 573 times)

julianbrelsford

complex search - mysql gets stuck

petednz

Re: complex search - mysql gets stuck