BLOB storage

From: David COSTE <dco_at_compaq.com>
Date: Wed, 5 Mar 2003 18:46:50 +0100
Message-ID: <fKq9a.5$JR.1@news.cpqcorp.net>

I would like to know in which case it advisable or not advisable to store blobs in rows.
I think it is better in each case to store them outside of the row (using the DISABLE STORAGE IN ROW clause), given the fact you must first do an insert to store your non blob data and then update the row to store the BLOBs. This should give more row migration and space fragmentation if you have a lot of small blobs.

What do you think ?

David COSTE
(OCP Candidate) Received on Wed Mar 05 2003 - 11:46:50 CST