Partition Blob Page Sharing???

Posted in 2015

DAN MUELLER — Wed, 04 Mar 2015 12:50:13 — source: IIUG Forums & Mailing Lists

Morn'n Folks, IDS 11.70.FC8 O/S Linux I want to know if different text columns from the same table will share the pages they use for the actual blob data. IE... If column1 is text and has a length of 1200 bytes, and column 2 has another text column with a length of 800 bytes, will these 2 blobs go on 1 or 2 pages? This is assuming 2k page size in the dspace and partition blobs. Thanx, Dan

↪ replying to DAN MUELLER

Art Kagel — Wed, 04 Mar 2015 13:02:30 — source: IIUG Forums & Mailing Lists

For partition blobs (ie IN TABLE) yes. Partition blobs work like regular rows. If less than a page they share. If bigger than a page, the trailing pieces share a page. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Mar 4, 2015 at 7:50 AM, DAN MUELLER <ddmueller@intercall.com> wrote: > Morn'n Folks, > > IDS 11.70.FC8 > O/S Linux > > I want to know if different text columns from the same table will share the > pages they use for the actual blob data. IE... If column1 is text and has a > length of 1200 bytes, and column 2 has another text column with a length of > 800 bytes, will these 2 blobs go on 1 or 2 pages? This is assuming 2k page > size in the dspace and partition blobs. > > Thanx, > Dan > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113ecaac1221d90510760f90