Re: [Phpgroupware-developers] addressbook model and integration with accounts

[Michael Dean]

On Sat, 2003-06-28 at 04:37, Ralf Becker wrote:
> > I would see there would be several key queries.  A list query (maybe 2
> > one for person and for orgs), one for each type of summary (person, org,
> > and user).  The full details query, which would be 3 or 4 queries
> > executed in sucession - which would give full record data.
> 
> I strongly disagree here for performance reasons. Within one class we 
> should use joins to pull the data of one "virtual" record together. 
> Specialy if we are querying for more then one record like in the 
> address-linsting or the search.

You can't do this for practical reasons.  You will get multiple records
back for the same contact.  You also do not need the full detail for a
contact every time.  Usually, lists can be done with name and perhaps
preferred addy and phone.

Mike