We have various client applications who will need data stored in MySQL database. We are planning to send data requests from these clients to MySQL database server through a DBMGR application.
We would like to keep the DBMGR as a single threaded application servicing a configurable number of connections. I have following questions on MySQL c api 1) Is there a way mysql_query and mysql_store_results can be done in an asynchronous way? The way we would like to do this, submit mysql_query on connection 1 check for outstanding requests. if a request exists, submit mysql_query on connection 2 check whether request is done on connection? if done, do mysql_store_result and pass the data to client ..... ..... 2) If not, is multi threading the only option to service multiple clients concurrently? Based on MySQL documentation, threading API interface was introduced from version 4.0 onwards. I do believe this kind of requirement is fairly common and am interested to know how a requirement like this was handled in a MySQL version before 4.0. Thanks, Raghu Udupa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]