Re: [SQL] primary keys as TEXT

On 7/31/06, Manlio Perillo <[EMAIL PROTECTED]> wrote: Because serial ids are only surrogate keys.My tables have well definited primary keys, the only problem is thatthey are of type TEXT (and spawn up to 3 columns).My concern is: how bad can be performance?  My guess is that the performance differe

Re: [SQL] primary keys as TEXT

Aaron Bono ha scritto: > On 7/28/06, *Manlio Perillo* <[EMAIL PROTECTED] > > wrote: > > Michael Glaesemann ha scritto: > > > > On Jul 28, 2006, at 17:37 , Manlio Perillo wrote: > > > >> There can be performancs problems in having primary keys of type >

Re: [SQL] primary keys as TEXT

On 7/28/06, Manlio Perillo <[EMAIL PROTECTED]> wrote: Michael Glaesemann ha scritto:>> On Jul 28, 2006, at 17:37 , Manlio Perillo wrote:>>> There can be performancs problems in having primary keys of type TEXT?>> What about having a primary key of 3 columns (all of type TEXT)? >> What defines a pro

Re: [SQL] primary keys as TEXT

Michael Glaesemann ha scritto: > > On Jul 28, 2006, at 17:37 , Manlio Perillo wrote: > >> There can be performancs problems in having primary keys of type TEXT? >> What about having a primary key of 3 columns (all of type TEXT)? > > What defines a problem in terms of performance is heavily depen

Re: [SQL] primary keys as TEXT

On Fri, 2006-07-28 at 03:37, Manlio Perillo wrote: > Hi. > > There can be performancs problems in having primary keys of type TEXT? > What about having a primary key of 3 columns (all of type TEXT)? The biggest problem with using text as a primary key or foreign key is that text types are locale

Re: [SQL] primary keys as TEXT

On 7/28/06, Manlio Perillo <[EMAIL PROTECTED]> wrote: Hi.There can be performancs problems in having primary keys of type TEXT?What about having a primary key of 3 columns (all of type TEXT)? If you are really worried about it, why not just use surrogate keys?  They are very easy to use.  Then your

Re: [SQL] primary keys as TEXT

On Jul 28, 2006, at 17:37 , Manlio Perillo wrote: There can be performancs problems in having primary keys of type TEXT? What about having a primary key of 3 columns (all of type TEXT)? What defines a problem in terms of performance is heavily dependent on your particular needs and requirem

[SQL] primary keys as TEXT

Hi. There can be performancs problems in having primary keys of type TEXT? What about having a primary key of 3 columns (all of type TEXT)? Regards Manlio Perillo ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster