Running multiple queries in parallel using the same JDBC connection
Hey Vertica Gurus,
Is it possible to run multiple queries in parallel using the same JDBC connection in Vertica? Or will they block, and the result will end up being sequential?
I am looking for a Vertica-specific answer. A few non-Vertica discussion forums suggest that this is DB/Driver specific.
I am well aware of connection-pooling and am already using it. My use case is to spawn multiple threads from a connection pool for a category of queries. Each category has a bunch of pre-queries, base-queries, and post-queries, and I would like to use the same connection for all queries in the context of the category.
If this is not possible, what strategies can you suggest to workaround this to achieve this?