com.vertica.jdbc.DataSource vs. apache..dbcp.BasicDataSource

Moderator: NorbertKrupa

Post Reply
vladif86
Newbie
Newbie
Posts: 6
Joined: Sun Oct 20, 2013 8:02 am

com.vertica.jdbc.DataSource vs. apache..dbcp.BasicDataSource

Post by vladif86 » Sun Oct 20, 2013 10:25 pm

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

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: com.vertica.jdbc.DataSource vs. apache..dbcp.BasicDataSo

Post by id10t » Thu Oct 24, 2013 7:07 am

Hi!

[DELETED]
Last edited by id10t on Sat May 09, 2015 3:32 pm, edited 1 time in total.

vladif86
Newbie
Newbie
Posts: 6
Joined: Sun Oct 20, 2013 8:02 am

Re: com.vertica.jdbc.DataSource vs. apache..dbcp.BasicDataSo

Post by vladif86 » Thu Oct 24, 2013 2:26 pm

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

Post Reply

Return to “JDBC”