Pooly wrote:
Hi,
2005/9/24, Lefteris Tsintjelis <[EMAIL PROTECTED]>:
Sujay Koduri wrote:
I think mysql does not allow multiple threads to act on the same connection.
You have to create a connection pool and pick one for each thread
You can use one connection for all your thread.
Just be sure to properly enclose it with a lock/mutex, and build you
query thread-safe.
for connecting :
sql.lock
sql.connect
sql.unlock
for query :
sql.lock
mysql_thread_init()
sql.query
sql.sotre_result
mysql_thread_end()
unlock
I think this simplifies things a lot! Thanks again!
Best Regards,
Lefteris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
