Guten Tag car.toper,

am Freitag, 24. April 2009 um 15:09 schrieben Sie:

> I am wondering... Is it worth while to optimize tables to fit into
> pages? My thought is that if you had a simple table:

> id integer
> name char(10)

> Rather than leave the name at 10 char's, round it up to 12 so the
> table is 16 bytes and will fit into a sector nicely. The only catch
> is that all the tables will have varchar's of lengths over 50 most
> of the time. Would that null and void such an optimization or not? Here is an example:

No : Firebird uses Run Length Encoding of the records it stores on disk
so the size of your record as defined will have nothing to do with the size
of the record store on disk

,
--
Mit freundlichen Grüssen
Hannes Streicher mailto:HStreicher@...