On Wed, Apr 3, 2013 at 12:25 PM, Markus Ostenried <mac...@gmail.com> 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]