On Wed, Aug 17, 2005 at 03:24:58PM -0500, Bruno Wolff III wrote:
> On Wed, Aug 17, 2005 at 12:09:12 -0600,
> Michael Schmidt <MichaelMSchmidt@msn.com> wrote:
> > I've searched the archives and found this question was asked in 2001 but never answered. Does the order of fields
ina table make a difference? In Paradox (from whence I come), there was some belief that reliability was increased if
memo(text) fields were placed at the end of the table. If field order does make a difference, does the EMS PostgreSQL
manager"reorder" function physically rearrange the fields?
> >
> > Thanks for your time in considering this basic question
>
> Some space can be saved by putting the columns with the largest alignments
> first.
> The columns are not moved around to do the above, but are kept in the
> declared order.
Ugh, and here I'd been doing it the other way around. I assume
variable-length stuff should always go last, right?
This make sense?
Variable goes last, always
Larger alignment before smaller
NOT NULL before nullable
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com 512-569-9461