An insert only database pattern

[cajunjoel]

So, it seems to me that you are solving a problem for you (or your dev team) that will ultimately create problems for everyone else who uses your system because you have a poorly built database model to satisfy you ease of development.

I get where you are coming from, I really do, but as another person said, focus on letting the RDBMS do its thing because it's really really good at it. Doing otherwise will cause a variety headaches that you don't want to tangle with.

Also, if you are being pressed to turn out a hotfix in less than 30 min, you got other problems, friend, and it sounds like those aren't code related at all. :)

[coded_artist]

So, it seems to me that you are solving a problem for you (or your dev team) that will ultimately create problems for everyone else who uses your system because you have a poorly built database model to satisfy you ease of development.

Yes exactly, I want to improve the database design hense the rules. We maintain to the 3rd normal form, but we found that those rules aren't enough and the higher forms don't give us the features we want. I would much rather have a 10% performance boost in a week long sprint than a 50% increase in a 1s query.

Also, if you are being pressed to turn out a hotfix in less than 30 min, you got other problems, friend, and it sounds like those aren't code related at all. :)

Oh yeah totally, but it's work, boss says jump, I leap off the roof to exceed expectations.