vertica 7 odbc slow
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
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
0