← Back to team overview

dhis2-devs team mailing list archive

Re: optionset for icd-10 is too slow.

 

Mark

As I said - selecting from an optionset with 22,400 values is VERY fast
(1-2 seconds), but you obviously need to know what sub-text to type in to
filter the list.

ICD-10 has at most around 70,000 codes, so it is possible using that many
will slow things down - I don't know.

Otherwise, we have already had some discussions around "hierarchical"
option sets (or grouped option values, if you prefer that term) as well as
the ability to automatically filter one option set based on the value in
another attribute/data element. Both would be useful for larger option
sets. (I'm not sure, but I think there are JIRA issues for both already?)

Regards
Calle

On 21 March 2017 at 11:44, Mark Polak <mark@xxxxxxxxx> wrote:

> Hey,
>
> It sounds like he means options in an optionSet (as he specifically
> mentions ICD-10)
>
> I think there are some issues with a large number of options in an
> optionSet, sorting being one of them. (We currently need to do this sorting
> on the client side, so it also partially depends on how powerful your
> machine is.) Perhaps the sorting for such large option sets should be
> disabled / improved.
>
> If you have other problems it would be best to create a Jira issue with a
> bit more information so we can try to replicate the issue. (
> https://jira.dhis2.org)
>
>
>
> On Tue, Mar 21, 2017 at 8:59 AM, Calle Hedberg <calle.hedberg@xxxxxxxxx>
> wrote:
>
>> Hi,
>>
>> Are you talking about a large number of Option SETS, or a large number of
>> Option Set VALUES?
>>
>> I've found the latter, at least, to be lightening fast: an option set for
>> the 22,400 sub-place names in South Africa responds in 1-2 seconds when
>> selecting an option value.
>>
>> If, on the other hand, you are talking about setting up large option sets
>> using the User Interface / Maintenance - well, then I agree that it's very
>> slow. But there's no need to add large option sets manually - just set them
>> up in e.g. Access or Excel or R or any similar piece of software, dump the
>> final data set out into e.g. CSV format, and import it. Quick and easy.
>>
>> Regards
>> Calle
>>
>> On 15 March 2017 at 03:26, 林晓东 <lin_xd@xxxxxxx> wrote:
>>
>>> hi.all
>>>
>>>    I found the dhis2 can't deal with large number of option set, too
>>> slow for maintaince.
>>>
>>>   can do it better?
>>>
>>>
>>>
>>>
>>> --
>>> 此致
>>>
>>>    林晓东
>>>
>>> 莫愁前路无知己,天下谁人不识君。
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>>
>> --
>>
>> *******************************************
>>
>> Calle Hedberg
>>
>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>
>> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>>
>> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>>
>> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>>
>> Email: calle.hedberg@xxxxxxxxx
>>
>> Skype: calle_hedberg
>>
>> *******************************************
>>
>>
>> _______________________________________________
>> 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
>>
>>
>
>
> --
> Regards,
>
>
> Mark Polak
> Software developer, DHIS 2
> University of Oslo
> http://www.dhis2.org <https://www.dhis2.org/>
> mark@xxxxxxxxx
>



-- 

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@xxxxxxxxx

Skype: calle_hedberg

*******************************************

References