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

[Dave Hall]

Michael Dean <address@hidden> wrote:

> 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 
> recordsback 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.

Yes, that is why the preferred options were added.

dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>