Performance improvements in 2.1
- Not Just a Contact Database
-
These optional components give you more power to connect and engage your supporters.

civiCONTRIBUTE
Online fundraising and donor management.

civiEVENT
Online event registration and participant tracking.

civiMEMBER
Online signup and membership management.

civiMAIL
Personalized email blasts and newsletters.
- Recent Blog and Forum Posts
-
Recent Blog Posts
- UK usergroup meeting in Manchester, 30 September
- 2.1 Beta 3 Available
- Keep CiviCRM for Drupal 5?
- Development plans and proposals for CiviCRM v2.2
- Collecting more information from CiviCRM installs ..
- 2.1 Alpha 4 Available
- 2.0.6 Bug Fix Release
- NTEN Donor Management Survey and CiviCRM ...
- Multi-language editing
- NTEN Donor Management Software Survey
Recent Forum Posts
Make your Voice Heard
So i've been looking a bit closely at performance for 2.1 (both database and usability) and am attempting to boost it up significantly compared to 2.0 (and prior). Here are some of the highlights
- We've introduced a new database cache table (civicrm_cache) to cache a few database queries that are repeated a lot. Some of the specific queries include listing all the fields available for the contact types (individual/org/household). This is a combination of the built-in fields (name, address etc) and the custom fields added by the user. This reduces the number of queries invoked from 5 complex queries to 1 simple cache query (and an un-serialize)
- We've added a column (group_type) to the profile table (civicrm_uf_group), so we know the profile type rather than recompute it every time we need it.
- Thanx to Dave Lange who reported and did some analysis on this, we've reduced the number of LOWER( dbColumnName) LIKE 'value' to skip the LOWER part. Email is now stored as lower case, so we can skip the LOWER part in all email comparison. In his tests, these have improved performance a fair bit
- Smart Groups
- Hierarchical Select
- Menu System
- DeDupe
- We will integrate the ACL changes into core either as a pluggable ACL architecture and/or via the hook system.
Overall 2.1 is shaping up to be a significant improvement over 2.0 :). You can get more details on the 2.1 feature set and release schedule on the CiviCRM v2.1 wiki page.
- lobo's blog
- Login or register to post comments





