CiviCRM Community Forums (archive)

yes surprisingly this has not come up before

since the code autogenerates the queries, there will always be quite a few unoptimized queries. Seems like you hit one of those spots. As with any software system, i suspect 80% of the orgs just use the top 20% of the features, and hence we have still a few more queries to optimize

I dont think its too hard to fix it. its just a matter of someone spending some time to optimize and test the queries. Auto-generating queries has the disadvantage that you need to understand the ramifications of the code etc (and hence writing unit tests help)

if you are interested on working on improving this in core jump on IRC and we can chat

lobo