Re: Does BLOB field affect performance ?

It does somewhat depend on what you do, but a BLOB field does not 
significantly reduce performance for SELECT operations.  If you have a 
table such as;

   CREATE TABLE a_table ( a INTEGER, b INTEGER, c INTEGER, d BLOB );

And your query is;

   SELECT a, b, c FROM a_table;

It will be exactly the same performance regardless of whether you have 
BLOB column 'd' defined or not.  Creating a table just to store BLOB 
data is not necessary.

Toby.

John Zoetebier wrote:

> Does a BLOB field in a record affect response time, even if the BLOB field is 
> null ?
> 
> I am pondering about adding a BLOB field to a record for future use.
> If however there is a significant performance issue, I may add an additional 
> table to store the BLOB field.
> The record in that table is read only of I know that the BLOB field is 
> present.
> 



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]