IDS Forum

RE: Blob Text Byte

Posted By: André Luiz Rufino
Date: Tuesday, 11 June 2013, at 11:32 a.m.

In Response To: Re: Blob Text Byte (Art Kagel)

Well, my situation is a "little" bit diferent. There is a list of tables bellow. It is ordering by row size
Tables RowSize
log_audit_logix 32204log_dados_trigger_antiga 32081wb_teste_email 30003frm_form_component 12738frm_comp_property_value 12156frm_comp_property_val_param 12154frm_component_property 12106frm_component 12103frm_param_component 11308crm_parametro_funcao 10106wb_cont_arq_wms 10000h_wb_cont_arq_wms 10000
I was thinking about one thing. Could It be good if create a different page size dbspace?
André

> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: Blob Text Byte [30478]
> Date: Tue, 11 Jun 2013 10:36:59 -0400
>
> With a bit of care, yes. You would have to read the data from the 'char'
> version of the table, insert a record mapping the text from the char column
> into a BLOB type host variable. In ESQL/C foor a dumb TEXT blob you would
> PREPARE the INSERT, DESCRIBE it, change the LOCTYPE of the TEXT column to
> LOC_MEMORY or LOC_USER (preparing the open, close, and read functions and
> linking them to the loc_t structure for the column) and either execute the
> INSERT or open a CURSOR for it and PUT rows to the cursor FLUSHing it
> periodically.
>
> Not sure that I would use a BLOB for a text field that's only 2K though.
> It's a lot of overhead and programming to support it. See my other
> message or other suggestions.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Tue, Jun 11, 2013 at 9:42 AM, André Luiz Rufino
> <andre_rufino@msn.com>wrote:
>
> > Yes, I imagined that. Any host aplicattion can do that ? PHP, Java for
> > example?
> >
> > > To: ids@iiug.org
> > > From: art.kagel@gmail.com
> > > Subject: Re: Blob Text Byte [30475]
> > > Date: Tue, 11 Jun 2013 09:15:56 -0400
> > >
> > > Oops forgot, converting the CHAR column to a TEXT or CLOB type is not
> > > trivial and cannot be done using a simple ALTER. You would have to create
> > > a new TEXT or CLOB column (or a whole new table), copy the string into
> > the
> > > TEXT or CLOB (or the whole row to the new table) using a host application
> > > (can't do it in SQL directly), then drop the old CHAR column or drop the
> > > old table and rename the new one and recreate any relational constraints
> > on
> > > it.
> > >
> > > Art
> > >
> > > Art S. Kagel
> > > Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Tue, Jun 11, 2013 at 7:43 AM, André Luiz Rufino
> > > <andre_rufino@msn.com>wrote:
> > >
> > > > Hi everyone,
> > > > In my production environment, I have a lot of tables with row buffer
> > than
> > > > page
> > > > size. It's because we have a lot of char(2000), and text columns. They
> > are
> > > > on
> > > > the same place that normal rows. I dont know what can be more efficent:
> > > > change
> > > > those columns to a blob ou sblos space, or change those columns to a
> > > > varchar
> > > > or lvarchar? First of all, Can I do it? Change a column char (2000) to
> > a
> > > > text
> > > > in a blob space?
> > > > Thanks,
> > > > André Luiz Rufino
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
> *******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --001a11c37420b535b104dee0b14e
> > >
> > >
> > >
> >
> >
> *******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
> >
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --089e01493c1e2a620304dee1bb8d
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

• Blob Text Byte
  André Luiz Rufino -- Tuesday, 11 June 2013, at 7:43 a.m.
  • RE: Blob Text Byte
    Alexandre Marini -- Tuesday, 11 June 2013, at 8:26 a.m.
    • RE: Blob Text Byte
      André Luiz Rufino -- Tuesday, 11 June 2013, at 9:04 a.m.
  • Re: Blob Text Byte
    Art Kagel -- Tuesday, 11 June 2013, at 9:09 a.m.
  • Re: Blob Text Byte
    Art Kagel -- Tuesday, 11 June 2013, at 9:15 a.m.
    • RE: Blob Text Byte
      André Luiz Rufino -- Tuesday, 11 June 2013, at 9:42 a.m.
      • Re: Blob Text Byte
        Art Kagel -- Tuesday, 11 June 2013, at 10:36 a.m.
        • RE: Blob Text Byte
          André Luiz Rufino -- Tuesday, 11 June 2013, at 11:32 a.m.
          • Re: Blob Text Byte
            Art Kagel -- Tuesday, 11 June 2013, at 12:08 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.