say i have a whole bunch of tables using an EAV (Entity Attribute Value) structure, i can update 20 values for 1 entity using a whole lot of inner joins in the query
which is more efficient, using all these inner joins or having 20 smaller queries which update 1 value at a time
In case of single row inner queries is more efficient and for multiple row insert you can can go for inner joins