Hm..ran into some heap space problems, probably rooted in some other mistake, but will have to stop now for today. In the mean time, you can have a look at the dump without the facilities, available here: http://97.107.130.50/files/
<http://97.107.130.50/files/>k On Mon, Sep 21, 2009 at 7:37 PM, Knut Staring <knu...@gmail.com> wrote: > Yes, Vacuuming is a good idea. Also, things were speeded up when I created > users that only have access to one region or country. > Right now I am adding 60000 facilities. Will make a backup file available > soon. > > Knut > > > On Mon, Sep 21, 2009 at 7:10 PM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> Hi Knut, >> You should start with a vacuum/analyze if you are using postgresq as as >> start. >> >> Can you give a dump of the DB, assuming it is not huge. Just the >> orgunit tables will do. I can try and take a look at it . >> >> Best regards, >> Jason >> >> >> >> On Sun, Sep 20, 2009 at 4:30 PM, Knut Staring <knu...@gmail.com> wrote: >> > On Fri, Sep 18, 2009 at 6:31 PM, Knut Staring <knu...@gmail.com> wrote: >> >> >> >> Hello, >> >> I am trying to populate the database directly with an enormous orgunit >> >> tree of the whole world (173 000 orgunits...). I have imported data to >> the >> >> following 3 tables: >> >> source, organisationunit, and orgunithierarchystructure. Do I need to >> >> populate any other tables? >> >> Also, in the organisationunit table, I had to remove the uniqueness >> >> constraints for both name and shortname, as there were tens of >> thousands of >> >> duplicate names - could this be the source of the below problems? I can >> of >> >> course try and generate unique names in some way. >> >> When starting DHIS, I get these messages: >> > >> > The difficulty stemmed from forgetting how to start the hierarchy: With >> NULL >> > as parentid for the top level. The only problem now is that it's a bit >> slow >> > - perhaps we can add some indexing? Jason? >> > Uniqueness is not needed, and neither is the orgunithierarchystructure >> table >> > - what is this for? >> > >> > >> http://www.openhealthconsortium.org/wiki/doku.php?id=administrative_boundaries >> > >> > >> > _______________________________________________ >> > 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 >> > >> > >> > > > > -- > Cheers, > Knut Staring > -- Cheers, Knut Staring
_______________________________________________ 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
