Discussion :

[7imito]

Bonjoura tous

J'espère bien que quelqu'un m'explique la différence entre DBspace SBspace dans informix merci bien d'avance.

Cordialement

[nelem75]

Bonjour,

Voici un morceau de la doc:

Sbspaces

An sbspace is a logical storage unit composed of one or more chunks that store smart large objects. Smart large objects consist of CLOB (character large object) and BLOB (binary large object) data types. User-defined data types can also use sbspaces.


En bref, les sbspace sont faits pour stocker des fichiers (des images, ...).

Les dbspaces sont faits pour stocker des tables sous forme de rangée. Une référence sous forme de descripteur pointe les données stockées dans les sbspaces.


Après, il y a la notion de blobspace. Voici de la doc pour les avantages des sbspaces sur les blobspaces:


Sbspaces have the following advantages over blobspaces:

* They have read, write, and seek properties similar to a standard UNIX file.

Programmers can use functions similar to UNIX and Windows functions to read, write, and seek smart large objects. IBM® Informix® provides this smart-large-object interface in the DataBlade® API and the Informix ESQL/C programming interface.
* They are recoverable.

You can log all write operations on data stored in sbspaces. You can commit or roll back changes if a failure occurs during a transaction.
* They obey transaction isolation modes.

You can lock smart large objects at different levels of granularity, and the lock durations obey the rules for transaction isolation levels. For more information on locking and concurrency, refer to your IBM Informix Performance Guide.
* Smart large objects within table rows do not need to be retrieved in one statement.


Hope this help.