We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Vertica Driver overhead queries — Vertica Forum

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
You can use Markdown in your post.