Handling massive inserts ( 100 plus million rows daily )
I have just inherited a process which is not meeting the time limits set by the business. I am trying to understand and suggest any workarounds to cut down the entire processing time, which now takes 8 Hrs.
What is the fastest and the most efficient way to do massive inserts, that is the bottom line ?
As of now the process adopted is ( this is the first step ) <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";}
What is the fastest and the most efficient way to do massive inserts, that is the bottom line ?
As of now the process adopted is ( this is the first step ) <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";}
0