Support non-blocking queries for MySQL in MyDAC or UniDAC
As many DB applications support multiple threads, we could benefit from non blocking MySQL queries. Of course we know that MySQL's C connector does not currently support asynch queries; At least not documented.
Athanasios Alekizoglou
shared this idea
-
Tuğrul HELVACI
commented
Still does not support non-blocking. I think it is a shame.
-
Carsten Worsoee
commented
+++ from me. This does not have to be a complete big-scale implementation of a new MyDAC-package - just implement the raw basics and let users handle the rest (if they want).
Perhaps this "primitive" implementation of the core MySQL async call Facebook has done can be used as inspiration?
-
Jan Holst Jensen
commented
+1 for supporting this in PgDAC (Postgres) too. Non-blocking queries do not seem to need a background thread (or at least only a very light-weight thread) if implemented like libpq's PQsendQuery:
-
Raptor Eugene commented
Please support non-blocking queries based on IOCP technology. Creating background thread for every active select statement leads to performance problems on heavy loaded systems.