Re: Time to say goodbye to the 2k page size?

"Chip Nickolett" <chip.nickolett@xxxxxxxxx> wrote in message
news:1193283664.370576.194330@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I personally look at page sizes as rules of thumb rather than blanket
generalizations, and then make the appropriate decisions based on your
specific environment.

Good point.

Which reminds me, iitables.tups_per_page seems wrong (in 9.1.0
(int.w32/119)). For instance if you have a table with just a CHAR(1) NOT
NULL column using 2kb pages, the reported value of tups_per_page is 670
(>>2**9).

Roy

PS: No smart-alec comments about the logical maximum number of key values in
that table. This is SQL. Anything goes.


.

Relevant Pages

  • Re: Time to say goodbye to the 2k page size?
    ... generalizations, and then make the appropriate decisions based on your ... environment you can pretty easily determine what page size is "best." ... The other consideration is memory configuration and utilization. ... two well configured caches than three or more caches ...
    (comp.databases.ingres)
  • Re: Unicycle Game [MMOCC]
    ... reminds me of Habbo Hotel (which I ... personally hate, but that's mostly because of the community...the ... environment is still well-designed). ...
    (rec.sport.unicycling)