Re: Question on IDS 10 page size
"Art S. Kagel (Oninit LLC)" <art@oninit.com> wrote in message news:mailman.394.1202134663.20610.informix-list@iiug.org... > First, I know of no bugs in the larger pagesize code. A pertinent question here would be "How often do you deploy it"? Not saying that there *are* problems with it, but you're most likely to know about any bugs in features you use a lot, so this is relevant ...
I can help out a little here. I'm running Informix 10.0.UC3 on RHEL4 with an 8k page size. The database tables are 4.4TB in size, across over 1000 chunks. It runs fine... (Even running Enterprise Replication into the tables) I do have a problem with the backup - but I'm working through this (like where to put it!). Hope it helps. Jarrod Teale -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Neil Truby Sent: Tuesday, 5 February 2008 11:24 a.m. To: informix-list@iiug.org Subject: Re: Question on IDS 10 page size "Art S. Kagel (Oninit LLC)" <art@oninit.com> wrote in message news:mailman.394.1202134663.20610.informix-list@iiug.org... > First, I know of no bugs in the larger pagesize code. A pertinent question here would be "How often do you deploy it"? Not saying that there *are* problems with it, but you're most likely to know about any bugs in features you use a lot, so this is relevant ... _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list DISCLAIMER: This email contains confidential information and may be legally privileged. If you are not the intended recipient or have received this email in error, please notify the sender immediately and destroy this email. You may not use, disclose or copy this email or its attachments in any way. Any opinions expressed in this email are those of the author and are not necessarily those of the Fonterra Co-operative Group. http://www.fonterra.com/
Neil Truby wrote: > "Art S. Kagel (Oninit LLC)" <art@oninit.com> wrote in message > news:mailman.394.1202134663.20610.informix-list@iiug.org... > > >> First, I know of no bugs in the larger pagesize code. >> > > A pertinent question here would be "How often do you deploy it"? > Not saying that there *are* problems with it, but you're most likely to know > about any bugs in features you use a lot, so this is relevant ... > Hi Neil, That's a good and valid point. Only I didn't say I hadn't seen any bugs myself. Honestly I can't say I've set up any large page dbspaces myself. What I said was that I don't know of any bugs in the larger pagesize code. I'm aware of several gotcha's in IDS 10 but nothing related to the larger pages. From other users who have used them, including some of Oninit's clients setup before I got here, it works just as advertised. Art S. Kagel Oninit =========================================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php ===========================================================================================
On Feb 4, 2:40 pm, "Art S. Kagel (Oninit LLC)" <a...@oninit.com> wrote: > Neil Truby wrote: > > "Art S. Kagel (Oninit LLC)" <a...@oninit.com> wrote in message > >news:mailman.394.1202134663.20610.informix-list@iiug.org... > > >> First, I know of no bugs in the larger pagesize code. > > > A pertinent question here would be "How often do you deploy it"? > > Not saying that there *are* problems with it, but you're most likely to know > > about any bugs in features you use a lot, so this is relevant ... > > Hi Neil, > > That's a good and valid point. Only I didn't say I hadn't seen any bugs > myself. Honestly I can't say I've set up any large page dbspaces > myself. What I said was that I don't know of any bugs in the larger > pagesize code. I'm aware of several gotcha's in IDS 10 but nothing > related to the larger pages. From other users who have used them, > including some of Oninit's clients setup before I got here, it works > just as advertised. > > Art S. Kagel > Oninit > > =========================================================================== ================ > Please access the attached hyperlink for an important electronic communications disclaimer: > > http://www.oninit.com/home/disclaimer.php > > =========================================================================== ================ I've also been at at handful of sites in the last few months that are utilizing CPS, with no issues or problems. When 10 first came out, I don't recall any issues. Also, considering how the feature was implemented, I can't imagine that "problems" would have been "large" if at all from the beta. Don't recall any stories like that, but that was long ago... Mark Scranton Xtivia Inc.
On Feb 4, 10:44 pm, "mark.scran...@gmail.com" <mark.scran...@gmail.com> wrote: > On Feb 4, 2:40 pm, "Art S. Kagel (Oninit LLC)" <a...@oninit.com> > wrote: > > > > > Neil Truby wrote: > > > "Art S. Kagel (Oninit LLC)" <a...@oninit.com> wrote in message > > >news:mailman.394.1202134663.20610.informix-list@iiug.org... > > > >> First, I know of no bugs in the larger pagesize code. > > > > A pertinent question here would be "How often do you deploy it"? > > > Not saying that there *are* problems with it, but you're most likely to know > > > about any bugs in features you use a lot, so this is relevant ... > > > Hi Neil, > > > That's a good and valid point. Only I didn't say I hadn't seen any bugs > > myself. Honestly I can't say I've set up any large page dbspaces > > myself. What I said was that I don't know of any bugs in the larger > > pagesize code. I'm aware of several gotcha's in IDS 10 but nothing > > related to the larger pages. From other users who have used them, > > including some of Oninit's clients setup before I got here, it works > > just as advertised. > > > Art S. Kagel > > Oninit > > > =========================================================================== ================ > > Please access the attached hyperlink for an important electronic communications disclaimer: > > >http://www.oninit.com/home/disclaimer.php > > > =========================================================================== ================ > > I've also been at at handful of sites in the last few months that are > utilizing CPS, with no issues or problems. When 10 first came out, I > don't recall any issues. Also, considering how the feature was > implemented, I can't imagine that "problems" would have been "large" > if at all from the beta. Don't recall any stories like that, but that > was long ago... > > Mark Scranton > Xtivia Inc. Thanks, this makes me feel better. I am always just very cautious when using new features because this seems when you get bit the most. I think that I am getting the feeling that you really need to test performance. I think we will obviously for some stupidly wide tables put them in larger page sizes. I will recommend holding off until we can really prove some benefit.