Skip to main content

vertica 7 odbc slow

  • May 3, 2014
  • 0 replies
  • 8 views

Tung
I am having a performance issue when running queries/insert/update on Vertica 7 via an ODBC connection.
Appriciate for any help.

odbc.ini
[VDB]
Driver = /opt/vertica/lib64/libverticaodbc.so
Servername = myPrd
Database = ccc
Port = 5433
UserName = my_writer
Password = newWriter
TxnReadCommitted = 1
#ConnSettings = SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED

Thanks