17.05.2015, 09:23
I wouldn't use JOIN for that as some of the data would be more than once so 4 queries for each table would be just fine.
About your second question, you don't have to update every single field but those that have changed only. That would recude the length of the query a lot.
About your second question, you don't have to update every single field but those that have changed only. That would recude the length of the query a lot.