The Vertica Database Forums

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

Hi!

[DELETED]

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