Execute asynchronous Queries (Non-blocking IO)
Brought to you by:
ickzon
Menu
▾
▴
#748 Execute asynchronous Queries (Non-blocking IO)
Affected by the hype around node.js, I wonder if it would be possible to enhance jTDS in a way that it uses asynchronous I/O to communicate with the SQL server. A statement or query will be sent to the SQL server and control is returned to the calling thread immediately. When the SQL server has finished execution, the result is signaled to the client. One client thread should be sufficient to react on those signals for all statements and dispatch the results.
I'm aware that you could easily create a thread pool with DB-worker-threads and let each worker-thread execute a blocking SQL query. That is not my question.
Any comments?