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 <angelo.rlco...@gmail.com>: > 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. >