On Thu, 10 Aug 2006, Michel Moreira wrote:

I dont think that saving the all the field data in one vcard string is
a good idea.

How about searching my contacts that live on some city, some info that
is in this vcard string?

It isnt good to add a field to each contact info that is available...

I think that can be created 2 tables, one with the contact info type
and one that has an 1-n relationship between the contacts table and
tis contact info type table, where u can put the info.

Then u can search freely withouth performance issues and store and
extends all the contact info without having too many empty fields.

This is a good idea. can we through some ideas on DB structure?


--
 21:50:04 up 2 days,  9:07,  0 users,  load average: 0.92, 0.37, 0.18
---------------------------------------------------------
Lic. Martín Marqués         |   SELECT 'mmarques' ||
Centro de Telemática        |       '@' || 'unl.edu.ar';
Universidad Nacional        |   DBA, Programador,
    del Litoral             |   Administrador
---------------------------------------------------------

Reply via email to