variable page size performance ?
Hello experts: System 1: aix 5.3, ids v11.50.fc2 system 2: aix 5.3, ids 9.40fc9 On system 1, table created with a 16k page size. On system 2, synonym pointing to above table. Just wondering what the performance impact might be with this sort of setup...seeing that v9.40fc9 doesn't have variable page sizes, and making sure that this will actually work. System 2 will also insert into the synonym as well as query it... Thanks for any and all help .... Peter Logan Senior Database Administrator Phone: 616/878-8309
Access to the synonym is handled like any distributed query, only the selected rows are transmitted back from the remote server, not whole pages, and they are kept in private session memory not in the buffer cache so the page size difference shouldn't make a difference. Art On Mon, Sep 22, 2008 at 9:23 AM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > Hello experts: > > System 1: aix 5.3, ids v11.50.fc2 > system 2: aix 5.3, ids 9.40fc9 > > On system 1, table created with a 16k page size. > On system 2, synonym pointing to above table. > > Just wondering what the performance impact might be with this sort of > setup...seeing that v9.40fc9 doesn't have variable page sizes, and making > sure that this will actually work. System 2 will also insert into the > synonym as well as query it... > > Thanks for any and all help .... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Thanks Art ... I figured as such .... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Date: 09/22/2008 10:16 AM Subject: Re: variable page size performance ? [13460] Access to the synonym is handled like any distributed query, only the selected rows are transmitted back from the remote server, not whole pages, and they are kept in private session memory not in the buffer cache so the page size difference shouldn't make a difference. Art On Mon, Sep 22, 2008 at 9:23 AM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > Hello experts: > > System 1: aix 5.3, ids v11.50.fc2 > system 2: aix 5.3, ids 9.40fc9 > > On system 1, table created with a 16k page size. > On system 2, synonym pointing to above table. > > Just wondering what the performance impact might be with this sort of > setup...seeing that v9.40fc9 doesn't have variable page sizes, and making > sure that this will actually work. System 2 will also insert into the > synonym as well as query it... > > Thanks for any and all help .... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.