dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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