Hi Antoine, Yes i understood that. But my problem is that using an index to access the array in the body takes a bit of time. Trying to figure out why.
Thanks, Ângelo Costa On Tue, Mar 17, 2015 at 10:36 AM, Antoine DESSAIGNE [via Camel] < ml-node+s465427n5764267...@n5.nabble.com> wrote: > Hi Angelo, > > The SQL component returns a List when you set the outputType as SelectList > (which is the default value), thus all the values are fetched at once. > > See the documentation here: http://camel.apache.org/sql-component.html > > Antoine. > > 2015-03-16 12:31 GMT+01:00 angelo.rlcosta <[hidden email] > <http:///user/SendEmail.jtp?type=node&node=5764267&i=0>>: > > > Hi Claus, > > > > Every time i try access ${body[0]} to get the first item returned from > the > > list from the DB seems a bit slow. Seems like lazy loading is enabled. > > > > Therefore wanted to try use lazy loading = false somehow to check if its > > faster. > > > > > > > > -- > > View this message in context: > > > http://camel.465427.n5.nabble.com/Sql-component-lazy-loading-tp5764211p5764216.html > > Sent from the Camel - Users mailing list archive at Nabble.com. > > > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://camel.465427.n5.nabble.com/Sql-component-lazy-loading-tp5764211p5764267.html > To unsubscribe from Sql component lazy loading?, click here > <http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5764211&code=YW5nZWxvLnJsY29zdGFAZ21haWwuY29tfDU3NjQyMTF8OTY0MzQzODU=> > . > NAML > <http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- View this message in context: http://camel.465427.n5.nabble.com/Sql-component-lazy-loading-tp5764211p5764270.html Sent from the Camel - Users mailing list archive at Nabble.com.
