Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Vertica JDBC Connection
Hi, We are trying to integrate drools with Vertica, We have used Vertica JDBC Driver 4.1.14 for integration with the JAVA code. But we found that update query is taking so much time as compared to other databases in execution through JDBC Driver. We have to use it for around 8 million updates, so it is not possible if updates are taking so much time. For only 1,000 records,more than 1 minute is consumed. We have tried both the options( batch update and normal update). Even if we tried with HIbernate framework, it doesn't help us. It is taking time in 'session.flush()' method. Please suggest any solution to improve the performance. Thanks, Murali