RE: TEXT field in Blob Space vs Table Space

Version? Platform? You might be able to better your performance by putting the text field into a different table and joining to that table when you need the textual information. Are you sure it is the text field which is slowing things down? I assume you have done update statistics...? What was the ISAM error that occurred at the same time as the 603? What are average, maximum and minimum sizes of one of your TEXT fields? Will >===== Original Message From Richard Krenek <rkrenek@ihs.com> ===== >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. 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. > >Thanks, >Richard Krenek ------------------------------------------------------------ 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/ ------------------------------------------------------------