Vertica Driver overhead queries
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
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
0