Home » RDBMS Server » Performance Tuning » Best Design for batch processing using BLOB Types
Best Design for batch processing using BLOB Types [message #610907] Tue, 25 March 2014 14:41 Go to next message
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;
Re: Best Design for batch processing using BLOB Types [message #610908 is a reply to message #610907] Tue, 25 March 2014 14:43 Go to previous message
BlackSwan
Messages: 22844
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/
Previous Topic: sql result cache for improving the performance (merged 4)
Next Topic: elapsed_time_delta in dba_hist_sqlstat
Goto Forum:
  


Current Time: Wed Oct 01 12:49:25 CDT 2014

Total time taken to generate the page: 0.11574 seconds