Aaron Bono ha scritto:
On 7/28/06, *Manlio Perillo* [EMAIL PROTECTED]
mailto:[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?
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
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 problem in
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
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
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
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
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 dependent on