|
Hi All, I was just watching this thread and wanted to share our possibly similar experiences from iHRIS. Admittedly I have not looked at the details of how DHIS is implementing dynamic attributes in the database, but I would suspect the design pattern is similar to how iHRIS has done its form and fields. (I have also seen this design pattern in openMRS). Although this flexibility has been great, it did have a significant impact when it came to reporting time. Even with proper indices, MySQL couldn't handle multiple joins and the reports quickly became essentially unusable. As a solution we had to implement a middle layer (form caching) which sits between the data storage system and the reporting system. We were able to do this only only after addaing a sufficient amount of meta-data about our fields and forms (e.g. the relationship between them, the SQL data types, etc.) I don't know how heavily you plan to make use of the dynamic attributes in reporting, so it may be a non-issue for you all, but it may be a topic for your design call. Cheers. -carl On 09/14/2011 10:13 AM, Bob Jolliffe wrote: OK. Lets try Friday morning 09h30 my time - that's 10h30 Oslo timeDial-in number: +1-424-203-8000 or Skype call to: freeconferencing.8000 Code: 553472 I know you are under pressure to finish this stuff so the intent is not to slow things up. Just keep us all pointing in same direction :-) Cheers Bob On 14 September 2011 14:40, Jo Størset <stor...@gmail.com> wrote:Den 14. sep. 2011 kl. 15.32 skrev Morten Olav Hansen:Can I suggest we fit in a brief design call this week to touch base? I have a freeconference number we can use. Maybe tomorrow or Friday? Lars are you around and/or available as well?Sure. I can tomorrow or Friday. Lars is in Uganda, but I'm sure he'll respond later if he has time for a conference call.I should also be able to make it.. Just give the time in advance :) Jo_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp |
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
