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? > >> 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 requirements. What are your > requirements? What > > profiling have you done to see where your performance bottlenecks > may be? > > > > I still don't have done profiling. > > Simply in the first version of my schema I used serial keys but the > result is ugly and it force me to do a lot of joins. > > > > Ugly? Not sure what you mean by that. >
Because serial ids are only surrogate keys. My tables have well definited primary keys, the only problem is that they are of type TEXT (and spawn up to 3 columns). My concern is: how bad can be performance? > I do understand the problem with so many joins. I use views so that the > joins are only delt with once (in the database) and then all my > applications run off the views. That way, the applications use very > simple queries. The views also allow me to change the table structure > (column names, more table normalization, etc.) without having to make > changes to the application. > View are a good idea, thanks. Regards Manlio Perillo ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
