Re: Need info on blobspace blobs
Posted in 2006
Madison, I use a blobspace with a 16K page, the DB (Business Objects) was installed with the BYTE/TEXT columns in the tablespace along with the other columns in the table, I moved it to a blobspace to stop the (horrendous) levels of logging. Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: Madison Pruet <mpruet@comcast.net> >To: informix-list@iiug.org >Subject: Re: Need info on blobspace blobs >Date: Tue, 20 Jun 2006 10:00:28 -0500 > >Ben Thompson wrote: > > Madison Pruet wrote: > > > >> I need an idea of the number of customers who are using blobspace > >> blobs as opposed to smart blobs. That is - how many customers are > >> using BYTE/TEXT as opposed to BLOB/CLOB > >> > >> Also I need some idea of the impact of not having HDR support > >> blobspace blobs. > > > > We would regard the loss of this functionality as bad news. It would > > force us to rewrite a lot of code to do separate writes to two different > > instances and cease upgrading in the mean time. > > > > Ben. > >Ben - I am talking about BYTE/TEXT which are stored in a blobspace. I >am not talking about BYTE/TEXT which are stored in the tablespace. > >If you enable logging on the BLOB/CLOB smart blobs or used tablespace >BYTE/TEXT within a logging database, then the large objects can be >replicated via HDR. Blobspace BYTE/TEXT columns have never been able to >be replicated via HDR because they are not logged. > >I am not talking about removing functionality. > >M.P. >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ Be the first to hear what's new at MSN - sign up to our free newsletters! http://www.msn.co.uk/newsletters