• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
best practice for multiple batch update

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
and memory peak usage

after 3 table, memory usage
memory peak usage

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


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?

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.