Re: Long column names...Performance issues?

From: Ed Prochak <edprochak_at_gmail.com>
Date: Fri, 5 Dec 2008 11:07:43 -0800 (PST)
Message-ID: <f1f9d5b0-e2fc-46ec-8f0d-2ff205fa42e8_at_t11g2000yqg.googlegroups.com>


On Nov 19, 4:15 pm, Gints Plivna <gints.pli..._at_gmail.com> wrote: []
> So the problem of course is to find where the golden mean lies. I'm
> quite sure it doesn't matter where it is exactly for you/your project
> but there is one thing which matters - stick with your standards. At
> least in your project. It is hard to work with code having variables:
> a
> ANEWVARIABLE
> A_NEW_VARIABLE
> a_New_Variable
> a_new_variable
> v_a_new_variable
> ANewVariable
> etc
> So stick with one standard and use it. My favourite is herehttp://www.gplivna.eu/papers/naming_conventions.htmyours may be
> somewhere else :)
>
> Gints Plivnahttp://www.gplivna.eu

You had me until the suggestion that all tables should have surrogate ID primary Keys. Otherwise I think your suggestions look good.

  Ed Received on Fri Dec 05 2008 - 20:07:43 CET

Original text of this message