RE: TEXT field in Blob Space vs Table Space
>===== Original Message From Rudy Fernandes <rferdy@americasm01.nt.com> ===== >Richard Krenek wrote: > >> Hello all, >> I'm creating a table that has a TEXT field. When asked where the >> blobspace should reside I choose the table space. Any query on this >> table is extreamly slow (about 800,000 records). I was wondering if the >> table would have been quicker if I would have stored that field in a >> Blob Space. > >In theory, it should be faster, especially for queries that do not involve >the Text field, simply because the data row size has, effectively, >reduced. Even when the query involves the text field, because Informix can >now get two disks to supply it data simultaneously, the query should run >faster. > >However, you must make sure that the Blobspace is actually on a different >physical disk from the dbspace in which the table is. If not, query >performance when retrieving data including the text field could be worse >than if the text was kept in the table's dbspace. I suppose this is because >the disk gets saturated by requests to retrieve data from two significantly >different locations (excessive head movement). > >> I had a blobspace created on our filesystem and was trying >> to do a speed test between the two choices but I got a -603 error when >> using the TEXT field that uses the blob space and I figured I would just >> ask before I go through all the trouble of seeing what is wrong with our >> blob space if it is not needed. > >No ideas on the 603 error. > >Rudy One other thing to remember is that date from blob spaces do not go through the BUFFERS. Depending on your usage of the blobs this can be good or bad. ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------