hg wrote: > I am writing a transaction server (socket-based) under windows. > > I use mysqldb to log info into MySQL. > > It is all working and I need now to decide whether to use forks > (CreateProcess I guess) or threads. > > I saw in another thread that some db engines did have issues with being > called from threads.
Some DBMS engines, particularly SQLite, actually run within the Python process. They might have issues with multiple threads, but multiple processes is a nonstarter. MySQL has its own process. It doesn't know nor care whether your application makes connections from different processes or different threads in the same process. > My gut feeling is to use threads (note: each transaction is finite, so > the process/thread die fairly quickly). > > Any insight ? Go with your gut. Python threads are reasonably portable, and work well on modern MS-Windows. -- --Bryan -- http://mail.python.org/mailman/listinfo/python-list
