Just an idea: You could have n data collector threads, that all put their results into a queue connected to 1 db thread, that stores the results into the db.
Cheers Franz GEIGER "Antal Rutz" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > Hi, All! > > I'm new to threading. I have some design questions: > Task: I collect data and store them in an RDBMS (mysql or pgsql) > > The question is how to do that with threading? > The data-collecting piece of the code runs in a thread. > > 1. Open the db, and each thread writes the result immediately. > (Sub-question: which is better: cursor object passed to the thread > or stored in a global var.) > 2. Threads return data, which is written to DB after that. > 3. Threads write to global variable, after 'join()' data is written. > (Can be used global (write-only) variables with threads at all?) > 4. ?... > > I think variable locking isn't an issue here because they are write-only. > > Maybe I have fundamentaly misunderstood something... > > Thanks > > -- > > > --arutz > -- http://mail.python.org/mailman/listinfo/python-list
