On Wed, Apr 3, 2013 at 12:25 PM, Markus Ostenried <macnoz@...> wrote:

>
> >
> > ... be
> > careful of the layout of your records. For example, if you sandwich your
> > CHAR[1] between two integer columns, you'll get three bytes of padding so
> > the integers align on natural boundaries.
> >
>
> Out of curiosity:
> Can the "sandwich problem" be controlled via "alter position"? IOW does
> column position affect the record layout on disk?

No, "alter position" just changes the logical position of the columns - what
you see from a SELECT *. The physical layout is determined when the table
is defined, and added fields always come last.

Good luck,

Ann

>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]