Hi,
What're Vertica recommendations regarding the data sources?
We've compared com.vertica.jdbc.DataSource vs. org.apache.commons.dbcp.BasicDataSource performance (we use it with Spring JdbcTemplate)
It looks that com.vertica.jdbc.DataSource performs faster , especially when the number of concurrent requests growing significantly (~30% faster)
Does someone has experience working with com.vertica.jdbc.DataSource ? Do you see the real performance gains working with it, comparing to BasicDataSource?
Thank you in advance,
VladiF
com.vertica.jdbc.DataSource vs. apache..dbcp.BasicDataSource
Moderator: NorbertKrupa
Re: com.vertica.jdbc.DataSource vs. apache..dbcp.BasicDataSo
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Sat May 09, 2015 3:32 pm, edited 1 time in total.
Re: com.vertica.jdbc.DataSource vs. apache..dbcp.BasicDataSo
Hi,
I think that using dbcp should improve performance since it manages connection pools.
That why I was thinking that dbcp should perform better than vertica data source (which doesn't have connections pooling ??)
Vladi
I think that using dbcp should improve performance since it manages connection pools.
That why I was thinking that dbcp should perform better than vertica data source (which doesn't have connections pooling ??)
Vladi