July 20th, 2012, 11:19 AM
Cut down Updation time 4 Updating 3 Lacs row's 10 columns with diff.-2 functions
We have 3,00,000 rows in a table. This table has a Primary Key named In_Id.
To update this table 10 columns, we have separate-separate 10 scalar functions with different-different definitions. In these functions we have to pass Primary Key of this table & get the output. It works fine when we work with small-small bunch of rows. But, when we try to update these 10 columns for all 3,00,000 rows then it takes 45-60 minutes to update the table.
The frequency of updating these 3,00,000 rows is depends on user requirement, means as & when user generates the report then before showing the results this updation process needs to execute.
How do we cut down this time?
July 20th, 2012, 02:31 PM