Subject | Re: [Firebird-Architect] Index structures |
---|---|
Author | Arno Brinkman |
Post date | 2003-06-08T13:08:16Z |
Hi Jim,
<snip stats>
important part into cache. That are not databases where the memory is much
lower than that what a database is (or would be in the future), but now i'm
ofcourse only speaking of a little fb-target-area.
expensive task on larger page sizes. While i always read (and thus adopt)
that a bigger page size should give a better performance? See for example
http://community.borland.com/article/interbase/makeibscream.pdf chapter 8,
but this seems to be not true at all. For faster index-lookups it seems a
small page size is the best.
Regards,
Arno Brinkman
ABVisie
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/
Nederlandse firebird nieuwsgroep :
news://80.126.130.81
<snip stats>
>I have to say that most of my customers (if not all) are having the most
> Pretty much what I expected. The index is fluffier, requiring more page
> reads. If
> the benchmark has to read disk pages, your scheme is slower. If it's
> running out
> of cache, it's faster. The real world doesn't run out of cache.
important part into cache. That are not databases where the memory is much
lower than that what a database is (or would be in the future), but now i'm
ofcourse only speaking of a little fb-target-area.
> I don't think it scales. The bigger the index the more you're hurt by theindex
> fluffier
> index. If your index goes an extra level, you lose big time. As the
> sizeThe extra-levels aren't there that much if they even are.
> increases relative to cache size, your cpu advantage is lost to increased
> disk i/o.
> CPU double in speed every 18 months. Disks double in speed every 25years.
> Trading increased disk traffic for lower CPU utilization isn't, to my oldOfcourse i've to agree with that, but the index-lookup seems to be a very
> foggie thinking, a win.
expensive task on larger page sizes. While i always read (and thus adopt)
that a bigger page size should give a better performance? See for example
http://community.borland.com/article/interbase/makeibscream.pdf chapter 8,
but this seems to be not true at all. For faster index-lookups it seems a
small page size is the best.
Regards,
Arno Brinkman
ABVisie
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/
Nederlandse firebird nieuwsgroep :
news://80.126.130.81