This is my question.
I have to build a Java based database middleware, it holds database connection, the no of middleware worker threads are equal to the no of database connections ( This is because, the no of concurrent database operation we can do on database is limited to the database connections). Any request coming in the system are queued and supplied to the worker theread if they are available.
In a scenario like this how can i take advantage of hyper thereading.
If I have a 4 processor " Then I will have 8 Virtual Processor ", then can i have 8 database connections, and 8 worker thereads as the ideal setup, will it work effectively.