Sql camel component iteration very slow

["angelo.rlcosta" <an...@gmail.com>]

Hi guys,

i am using a camel sql component and then iterating the results using
${body[0]} but this operation (getting index 0 of body) seems to be very
slow any idea why?

Thanks,



--
View this message in context: http://camel.465427.n5.nabble.com/Sql-camel-component-iteration-very-slow-tp5763372.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Sql camel component iteration very slow

["angelo.rlcosta" <an...@gmail.com>]

Hi everyone,

i've just tested with apache camel 2.14 but the issue still happens. Any
idea why accessing ${body[0]} is slow?
Note that accesing ${body} is very fast.

Thanks again,



--
View this message in context: http://camel.465427.n5.nabble.com/Sql-camel-component-iteration-very-slow-tp5763372p5763508.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Sql camel component iteration very slow

["angelo.rlcosta" <an...@gmail.com>]

Hi yogu13, 

as per my understanding this is related to the camel sql component version
2.10. AFAIK there has been some improvements in this sense in 2.14 which i
will try use.

Thanks for the input.



--
View this message in context: http://camel.465427.n5.nabble.com/Sql-camel-component-iteration-very-slow-tp5763372p5763464.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Sql camel component iteration very slow

[yogu13 <yo...@gmail.com>]

Hello Angelo,

Please give more information on the route ... there are factors which can
affect your processing such as 

1. absence of connection pool
2. accessing DB through JDBC / SSL
3. the database itself is slow or access to db is slow from the machine
itself.

Lastly how did you conclude that getting the results ${body[0]}is slow?

Regards



--
View this message in context: http://camel.465427.n5.nabble.com/Sql-camel-component-iteration-very-slow-tp5763372p5763442.html
Sent from the Camel - Users mailing list archive at Nabble.com.