All associated data in one database or split into multiple databases?
Wed, 04/18/2012 - 15:42
I'm developing an asset tracking app. An asset consists of an arbitrary number of attributes. It also has file attachments and notes. I broke the attributes, attachments and notes out into separate databases, but it makes the program logic a little more complex. I'm wondering if the performance gains by using separate databases that I'm picturing in my mind (with no real data to back them up) are really much better than just storing all of the objects in an assets database and giving them a 'type' field to differentiate them?
Thanks,
Troy
In 1.8, it won't really matter. There could be a slight difference if one has lots of changes when others have less changes owing to how often the datafiles will be fragmented, but otherwise it shouldn't really matter.
In 2.0, if running views over the data, it can matter but it's outside the critical path for most requests.