Hi Junior, You can enable streaming to reduce the time that taken to build the whole XML. and also you can increase the fetch size in the query [1], then the number of rows fetched with each database round trip for a query will be increased, so this will also reduce the time significantly.
[1] https://docs.wso2.com/display/DSS322/Advanced+Query+Properties Thanks, Madhawa On Wed, Jul 19, 2017 at 6:45 AM, Júnior <[email protected]> wrote: > Hi, > > We have a query that is being exposed using DSS. > > The query by itself take a lot of time, because it brings a lot of data, > but we noticed that it is taking a lot of time to build the XML that is > returned by the service. > > Is there any config that we could make to improve the XML creation > performance? > > Any tips for this kind of scenario? > > Thanks > -- > Francisco Ribeiro > *SCEA|SCJP|SCWCD|IBM Certified SOA Associate* > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Madhawa Gunasekara* Senior Software Engineer WSO2 Inc.; http://wso2.com lean.enterprise.middleware mobile: +94 719411002 <+94+719411002> blog: *http://madhawa-gunasekara.blogspot.com <http://madhawa-gunasekara.blogspot.com>* linkedin: *http://lk.linkedin.com/in/mgunasekara <http://lk.linkedin.com/in/mgunasekara>*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
