Say that we have 2 different types of bullets and each time we are shooting the gun, we are checking which one is on the chamber to be able to get quite a lot of variables of that specific bullet from the database row.
If we are shooting in full automatic mode, there will be 10-15 checks per second…
What is better for this situation?
A + Having a unique global database and struct for all the ammo, including description, names, materials, arrays and everything related to the ammo but some unrelated to the variables needed on this situation (but we will have just only one database for all the ammo)
B + HandCraft a special struct and database for this special situation where we will get the variables used only
C + A Totally Different Approach
I mean, when getting the Data Table Row, is the engine iterating anyways to all the columns even if we are getting only the ones we are using?
Which way will be the most performance optimal?