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

Thank you very much for the clarifications But (there is always this BUT :( !!) We insert our data in UTC format into TZ columns, then when selecting the data we want to take into account the client timezone . So per request/session we have to set (somehow) the client timezone That why we're thinkin...

The timezone is : Israel
Not sure I understand. Why it's important?

Hi,
Yep it's TZ
vladi

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...

Hi All, Please help us to resolve the following doubt: Are the these two line equivalent ? 1. ....and visit_start_time_15m at timezone 'GMT' >= to_timestamp('01/01/2013','dd/mm/yyyy') 2. ....and visit_start_time_15m >= to_timestamp('01/08/2013','dd/mm/yyyy') at timezone 'GMT' The first line causes f...