dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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