| commit | e46667e641cd1c60998e1ccab4b60531d5b12ef7 | [log] [tgz] |
|---|---|---|
| author | Dmitri Plotnikov <dplotnikov@google.com> | Thu Aug 20 21:56:43 2009 -0700 |
| committer | Dmitri Plotnikov <dplotnikov@google.com> | Thu Aug 20 21:56:43 2009 -0700 |
| tree | fbdf91f117e1c6795218e0754e3c977cc1ebe657 | |
| parent | 038c3db1b54dd9313c10c212025d37ca8a9e660f [diff] |
Introducing AGGREGATED_PRESENCE - thanks to JSharkey for the idea. This new DB table is maintained in memory and summarizes the presence status and custom status for each (aggregate) contact. With the help of this table, we avoid having to do GROUP BY and MAX(status) when running contacts summary queries. An added benefit is that we can now get the latest custom status update as part of the summary query.