Database Administration (MOSC)

MOSC Banner

Performance : difference between CLOB, BLOB ?

edited Apr 21, 2010 3:11AM in Database Administration (MOSC) 4 commentsAnswered
Hi,

Our application generates files in different format : .mat , .xls .

Actually these files are transformed in text format and then stored in the database in a CLOB column.

But we are experiencing performance problems.

Would the performances be better if we used a BLOB column ?

Or would it be better to use the BFILE type to point to theses files ?

Rgds,

Rachel

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center