I will create program that will update data in database. The update process will be triggered if I do insert data in table. The update process will computational costly. This is the idea of my update process :
I will have 3 tables (A,B,C) and each of it will have data aroud 100.000-200.000 records
I will have table D to save table A, B, C record count
I will have table E to save table A, B, C, D calculation, the calculation including multiplication, division and log base 2
I will insert data to table A, B, C and after that data in table D and E must be updated
This process can be repeated 3-5 times in every update
Which one is faster, doing update programmatically or using trigger?