Varbyte fields

sabety · Post by **sabety** » Fri Jun 22, 2001 10:12 am

I have a large varbyte field for holding publication quality TIFF images (8MB+ each). So far 19 records and I notice significant slowness in search results, and only in the table with a lot of data in the varbyte field (all my other tables also have the same schema though rarely use the varbyte field). I am not trying to select the varbyte field in the results listings either. I am assuming Texis can handle large binary files directly without the use of indirects. Is that right? If so, what could be the problem?

thanks

Post by **John** » Fri Jun 22, 2001 11:45 am

If you have large data that you are not frequently selecting it is advisable to store it in a BLOB field, as that will not be read in when the rest of the record is read.