I've started to research ORMs, serialization etc, and I'm curious to hear people's experiences with storing serialized over raw data or some combination thereof. It would seem that in most cases, storing the serialized object would be more efficient (recognizing that this is not always true).
If I do a quick calculation: if a is the time it takes to query the DB and b is the time to create the object then the equation is something like n(ka+kb) where n is the number of times you access the data and k is the amount of datae.g. 3(4a+4b) is accessing four rows three times. However, if you store the serialized object you're looking at something more like nka+kb+some delta (the change in a w/ respect to b?), which is conceivably smaller.
What's your experience with this? I've found several articles, but I'd love to see some benchmarks with hard numbers. Have you found any compelling articles that outline the issue?
If I do a quick calculation: if a is the time it takes to query the DB and b is the time to create the object then the equation is something like n(ka+kb) where n is the number of times you access the data and k is the amount of datae.g. 3(4a+4b) is accessing four rows three times. However, if you store the serialized object you're looking at something more like nka+kb+some delta (the change in a w/ respect to b?), which is conceivably smaller.
What's your experience with this? I've found several articles, but I'd love to see some benchmarks with hard numbers. Have you found any compelling articles that outline the issue?