dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

You can now find a 5MB postgres backup file at
http://97.107.130.50/files/ which
has 245427 orgunits, including 60 000 facilities.
Also, the speed is much better when running the database on the same machine
(I was using a server on the LAN before).

Though we have a lot of orgunit information now, there are certainly a lot
missing (e.g. we don't have facilities for many countries), and a lot of
errors. My idea is that we could run this as a master database on a server
(at UiO?), and give access to certain country users who can help correct it
(we should already be in a position to improve things substantially for
countries where DHIS has been introduced).

Knut

On Mon, Sep 21, 2009 at 7:41 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> 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 <knutst@xxxxxxxxx> 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.pickering@xxxxxxxxx> 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 <knutst@xxxxxxxxx> wrote:
>>> > On Fri, Sep 18, 2009 at 6:31 PM, Knut Staring <knutst@xxxxxxxxx>
>>> 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@xxxxxxxxxxxxxxxxxxx
>>> > Unsubscribe : https://launchpad.net/~dhis2-devs
>>> > More help   : https://help.launchpad.net/ListHelp
>>> >
>>> >
>>>
>>
>>
>>
>> --
>> Cheers,
>> Knut Staring
>>
>
>
>
> --
> Cheers,
> Knut Staring
>



-- 
Cheers,
Knut Staring