← Back to team overview

dhis2-users team mailing list archive

Re: webapi for dataset post slowly!

 

Hi easy,

- what version of dhis2 are you on?

- what is your server setup, ie. JAVA_OPTS ?

- approx how many datavalues do you have in your db?

Shouldn't really take that long.

Lars



On Wed, Jul 17, 2013 at 8:59 AM, easy <lin_xd@xxxxxxx> wrote:

> it's true we do in localhost. we do like this:
>
>  [other  database] ===jdbc===Mirth connect gateway==http sender== dhis2
>
> DHIS2 and the gateway all in same server.
> I use the curl do the post. will cost 15s for :
>
>
> <dataValueSet xmlns="http://dhis2.org/schema/dxf/2.0";>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysx09001"
> value="急救中心"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysx09002"
> value="510000152088"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysx09003"
> value="450903450"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysx09004"
> value="国有全资"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysx09005"
> value="急救中心、"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysx09006"
> value="非营利性医疗机构"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysx09007"
> value="自流井区"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysx09008"
> value="510302002"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysx09010"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysx09011"
> value="1"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysx09013"
> value="3"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysx09014"
> value="否"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysx09015"
> value="否"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysx09016"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyxx10001"
> value="流井区檀木林"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyxx10002"
> value="643000"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyxx10003"
> value="0813-2201981"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyxx10004"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyxx10005"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyxx10006"
> value="20020101"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyxx10007"
> value="刘建辉"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyxx10033"
> value="是"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyxx10034"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyxx10035"
> value="是"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyxx10036"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszycw02003"
> value="4.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyry01001"
> value="72.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyry01002"
> value="37.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyry01003"
> value="18.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyry01004"
> value="8.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyry01005"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyry01006"
> value="7.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03001"
> value="1110.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03002"
> value="6663.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03003"
> value="6663.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03004"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03005"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03006"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03007"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03008"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03009"
> value="0.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03010"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03011"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03012"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03013"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03014"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03015"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03016"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyjj03017"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysb04001"
> value="19.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysb04002"
> value="15.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysb04012"
> value="8.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysb04013"
> value="7.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysb04014"
> value="9.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysb04015"
> value="9.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysb04016"
> value="9.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysb04017"
> value="18.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysb04018"
> value="0.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysb04019"
> value="10.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysb04020"
> value="1.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysb04021"
> value="9.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysb04022"
> value=""/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysz05001"
> value="2801.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszysz05002"
> value="2801.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyzc06001"
> value="1983.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyzc06004"
> value="1983.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyzc06008"
> value="142.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyzc06007"
> value="1841.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyhp08001"
> value="5024.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyhp08002"
> value="40.0"/>
> <dataValue period="2012" orgUnit="2062225" dataElement="wszyhp08003"
> value="325.0"/>
> </dataValueSet>
>
>
>
> --
> 此致
>
>    林晓东
>
> 莫愁前路无知己,天下谁人不识君。
>
> At 2013-07-17 13:06:11,"Morten Olav Hansen" <mortenoh@xxxxxxxxx> wrote:
>
> This is probably due to a very slow connection. Nothing that can really be
> done on our side. If you experience slowness even when trying it out
> locally, please tell us.. and we will look into it (post a dataValueSet
> should take no time at all)
>
> --
> Morten
>
>
> On Wed, Jul 17, 2013 at 10:13 AM, easy <lin_xd@xxxxxxx> wrote:
>
>> Hi,all
>> I have do post data with webapi,but, often the client said:
>> timeout,response very slow, how to speed up?
>>
>> --
>> 此致
>>
>>
>> 莫愁前路无知己,天下谁人不识君。
>>
>> At 2013-07-16 14:22:12,"Lars Helge Øverland" <larshelge@xxxxxxxxx> wrote:
>>
>> Hello easy,
>>
>> sorry, I don't think there is a perfect solution to this at the moment.
>> My best suggestion would be to create a data set for it and a script which
>> populates the data based on the org unit level.
>>
>> Lars
>>
>>
>> On Sun, Jul 7, 2013 at 12:29 PM, easy <lin_xd@xxxxxxx> wrote:
>>
>>> Hi,all,
>>>
>>>     I have a question: I want do a evaluation about org's device
>>> situation, there are some standard configuration number for different level
>>> of org( state hospital : 5, county hospital 3,...), and the org will report
>>> its actual installed device. I will do a report about the gap of actual
>>> number of devices and standard number of its belong level.
>>>    how can I store the standard configuration  number of device in
>>> dhis2? if define a dataset and assign to org, there will be much redundency
>>> data.
>>>
>>>   standard  configuration table:
>>>              state         county         village
>>>           (A,  B, C)   (A, B, C)   (A, B, C)
>>> dev-a  30 20 10    15 12 10        8 4  2
>>> dev-b  ......
>>> ...
>>> ------------
>>> org's report:
>>> org name, state a, dev-a ,8
>>> org name, state a, dev-b ,4
>>> .......
>>>
>>> will get a gap report .
>>>
>>>
>>>
>>> --
>>> 此致
>>>
>>>   easy
>>>
>>> 莫愁前路无知己,天下谁人不识君。
>>>
>>> At 2013-07-06 22:31:51,"John Ojo" <jnojo@xxxxxxxxx> wrote:
>>>
>>> Thank you so much Lars. For now, I need the constants in the indicator
>>> numerator/denominator ui. If there's a need to have it in other places, I
>>> would let you know.
>>>
>>> Best regrads,
>>> John
>>>
>>> *John Ojo MD, FMCPH
>>> *
>>> Accra, Ghana.
>>> Mobile: +233 234691626
>>> Skype:  Johnojo
>>> Email: jnojo@xxxxxxxxx <jno@xxxxxxxxxxxxxxxxx>
>>>  <http://www.corridor-sida.org/>
>>>
>>>   ------------------------------
>>>  *From:* Lars Helge Øverland <larshelge@xxxxxxxxx>
>>> *To:* John Ojo <jnojo@xxxxxxxxx>
>>> *Cc:* DHIS developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>; dhis1-users <
>>> dhis2-users@xxxxxxxxxxxxxxxxxxx>
>>> *Sent:* Saturday, July 6, 2013 3:20 PM
>>> *Subject:* Re: [Dhis2-devs] Maximum number of Constants
>>>
>>> Hi John,
>>>
>>> there are no constraints on constants.
>>>
>>> At the moment constants render in a small list area in indicator
>>> numerator/denominator UI, might be inconvenient to work with but that can
>>> be fixed, let us know.
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>>
>>>
>>> On Sat, Jul 6, 2013 at 4:12 PM, John Ojo <jnojo@xxxxxxxxx> wrote:
>>>
>>> Hi,
>>>
>>> Please, is there a cap on the number of Constants that can be defined in
>>> DHIS2 version 2.12? If yes, then what is the maximum number of constants
>>> that can be defined?
>>>
>>> A design strategy I am adopting may require me to define some constants
>>> and this may run into a few thousands. Therefore, it is crucial for me to
>>> know before hand if there's a limit on the number of constants I can define
>>> before I embark on my design.
>>>
>>> I'm using the live version of DHIS2 on a Windows 7 platform.
>>>
>>> Thank you.
>>> John
>>>
>>> *John Ojo MD, FMCPH
>>> *
>>> Accra, Ghana.
>>> Mobile: +233 234691626
>>> Skype:  Johnojo
>>> Email: jnojo@xxxxxxxxx <jno@xxxxxxxxxxxxxxxxx>
>>>  <http://www.corridor-sida.org/>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

References