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?

Read more here: Update data programmatically in code(Java) or in database using trigger (MySQL)?


If you know the solution of this issue, please leave us a reply in Comment section, to update the question.

Related Wordpress search:

, , , , , ,

Wordpress related questions and answers: