Possible to use one connection for multiple concurrent queries?
Posted by:
Apachez
Date: February 28, 2006 08:37PM
Does anyone know if its possible to use one dbh (connection) for multiple sth (queries) at the same time in perl with DBI/DBD?
Today I use a temptable method which I fill up with the result from up to 20 queries which run one after another. The average time (top) for each query is 3 seconds on this particular hardware. This means that the total executiontime is up to 60 seconds (20*3) for this script to complete.
But if I could run these queries using threads in perl the total time would be something like 4 seconds instead of 60 seconds. By using one single connection they all would fill the same temporary table (since temporary tables are locked to the connection which they were created by and once that connection disconnects the temptable is removed).
Is this possible or am I forced to use a "real" table along with one connection per thread in order to be able to concurrently fill my resulttable with data from these up to 20 queries ?
Subject
Written By
Posted
Possible to use one connection for multiple concurrent queries?
February 28, 2006 08:37PM
November 09, 2006 11:25AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.