Thank you Madhawa, I will give it a try!
Thanks 2017-07-18 23:48 GMT-03:00 Madhawa Gunasekara <[email protected]>: > 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>* > -- Francisco Ribeiro *SCEA|SCJP|SCWCD|IBM Certified SOA Associate*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
