Saturday, February 25, 2012

Performance of "text" versus "image" datatypes (SS2000)

In terms of simple insertion and selection, is there any appreciable performance difference between text and image? (assuming the size of the data in bytes would be roughly equal)

Please also assme we're storing all LOBs out of row.

Thanks!

It would be the same. However, if your lob is nothing more than some very long string, putting it 'text' column would be a better fit.

No comments:

Post a Comment