Re: Pinning Objects
From: ddf <oratune_at_msn.com>
Date: Mon, 20 Jul 2009 10:35:23 -0700 (PDT)
Message-ID: <523ce77a-8027-4922-9ede-261020e41cdf_at_b14g2000yqd.googlegroups.com>
On Jul 20, 11:57 am, The Magnet <a..._at_unsu.com> wrote:
> Hi,
>
> We want to pin a couple of tables, hoping to increase some
> performance. From the docs, a pinned table means less reads from
> disk, etc.
>
> If the table gets updated or inserted into, is there any advantage to
> this? If yes, how does the committed transactions get saved?
Date: Mon, 20 Jul 2009 10:35:23 -0700 (PDT)
Message-ID: <523ce77a-8027-4922-9ede-261020e41cdf_at_b14g2000yqd.googlegroups.com>
On Jul 20, 11:57 am, The Magnet <a..._at_unsu.com> wrote:
> Hi,
>
> We want to pin a couple of tables, hoping to increase some
> performance. From the docs, a pinned table means less reads from
> disk, etc.
>
> If the table gets updated or inserted into, is there any advantage to
> this? If yes, how does the committed transactions get saved?
Why do you not consider using the KEEP pool?
http://oratips-ddf.blogspot.com/2008/05/thats-keeper.html
David Fitzjarrell Received on Mon Jul 20 2009 - 12:35:23 CDT