To all of you experienced database designers.
I am a self thought Database programmer, and since I did not followed any formal training some things are a little confusing still...
What is the best way to update an inventory table? My question is if the correct approach is to do it each time a product is selected and processed, or to wait until the whole sale transaction (like a full invoice) is finished and do a 'bulk' update.
I'd like to hear some expert comments.
Thank you in advance.
Ulises