Querying An Int Column From Table That Also Stores Blob Column (Performance)
If you select an INT column from a table that also has a medium/large BLOB column (without selecting the BLOB column) will the query take longer than if the BLOB column was not there?
I am wondering if I should move the BLOB column to a separate table. Does the query duration depend mostly on the size (bytes) of a table or is it based mostly on the columns being selected?
I realize there are potentially a number of factors involved but I am asking in general terms.