Skip to main content

Vertica Driver overhead queries

  • December 3, 2014
  • 0 replies
  • 2 views

Yehuda_Ari_Boro
Hi,
Using vertica driver 4.x we've noticed "wrapping" queries to each query we manually issue.
Examples:
COMMIT
select compliance_level,compliance_message from vs_databases limit 1
select get_config_parameter('MaxAttrSize')
select get_config_parameter('TransactionIsolationLevel')
select version()
ROLLBACK


Upgrading to version 6.x we see that the "COMMIT" is still there.

These additional queries are running 10s of thousands of times a day, and i'm sure are burdening the system.

I'm getting this information by querying the dc_requests_x and the query_requests
Any way to eliminate the overhead to the query we issue only? (hopefully a solution for both versions of the driver)

Thanks a lot,
Yehuda