OraFAQ Forum: Performance Tuning » Best Design for batch processing using BLOB Types

Home » RDBMS Server » Performance Tuning » Best Design for batch processing using BLOB Types

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Best Design for batch processing using BLOB Types [message #610907]

Tue, 25 March 2014 14:41

luxofmcc
Messages: 2
Registered: May 2011

Junior Member

I need suggestion on designing the database.

My requirement is Processing 2 million records using batch process.

Table Name: Workarea_tmp
Request_No:Number
col1,col2,col3 : BLOB
Status_Cd: Varchar2(10);

First Process will insert values for Request_NO, col1 and status as "Start"

Second Process will update the Col2 with BLOB (PDF DATA)then update the status as "Formatted" ;

Third Process will update the Col3 with BLOB (PDF) then update the status as
"Generated" ;

Then the Col3 value has to be fetched for the given request NO ;

Update the status as "Completed";

Once the status is completed the records are no more needed in the table;

The Completed records has to be archived in another table;

Can anyone Please suggest me to design the database to process this 2 million records that too with BLOB Datatypes (the size in the column would be 200 to 1000 KB).

Also please suggest me will it enhance the performance if we delete the "completed" records from the table;

Report message to a moderator