03.03.2016 16:20, Vlad Khorsun wrote:
>> will you believe my numbers?..
> Why not ?
Exactly because of
> special case, but very far from real life, i'm afraid.
> I guess you have join on long strings.
Not much long: varchar(2000) filled with rpad('', 2000,
uuid_to_char(gen_uuid())).
> T1 (128)
> Primary pointer page: 180, Index root page: 181
> Total formats: 1, used formats: 1
> Average record length: 2021.06, total records: 32
> Average version length: 0.00, total versions: 0, max versions: 0
> Average fragment length: 0.00, total fragments: 0, max fragments: 0
> Average unpacked length: 2006.00, compression ratio: 0.99
> Pointer pages: 1, data page slots: 16
> Data pages: 16, average fill: 50%
> Primary pages: 16, secondary pages: 0, swept pages: 0
> Empty pages: 5, full pages: 10
> Fill distribution:
> 0 - 19% = 5
> 20 - 39% = 0
> 40 - 59% = 1
> 60 - 79% = 10
> 80 - 99% = 0
>
> T2 (129)
> Primary pointer page: 200, Index root page: 201
> Total formats: 1, used formats: 1
> Average record length: 2020.43, total records: 81920
> Average version length: 0.00, total versions: 0, max versions: 0
> Average fragment length: 0.00, total fragments: 0, max fragments: 0
> Average unpacked length: 2006.00, compression ratio: 0.99
> Pointer pages: 17, data page slots: 27176
> Data pages: 27176, average fill: 75%
> Primary pages: 27176, secondary pages: 0, swept pages: 0
> Empty pages: 4, full pages: 27171
> Fill distribution:
> 0 - 19% = 4
> 20 - 39% = 0
> 40 - 59% = 1
> 60 - 79% = 26766
> 80 - 99% = 405
I wonder why number of fetches is so high?..
--
WBR, SD.
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
