+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Best Practices (https://forum.codeigniter.com/forumdisplay.php?fid=12)
+--- Thread: best practice for multiple batch update (/showthread.php?tid=77164)
best practice for multiple batch update - t3ppei - 07-27-2020
i've created a function to update a local database
i'm using data from API and update local table with update batch
from table no 1 (around 8000 rows and 15 columns)
i got memory usage
64976504
and memory peak usage
144559440
after 3 table, memory usage
112891344
memory peak usage
152110656
i've increase memory limit to 256
i update the 3 table in 1 function, and theres 4 more table
is there any best practice to do batch update?
batch update in the model, and the function call it 3 times for the 3 table
thank you
RE: best practice for multiple batch update - php_rocs - 07-28-2020
@t3ppei,
Have you verified that your batch queries are efficient? Have you done database maintenance to make sure that your database is at it's peak performance? How long does your batch update take to complete?