On May 20, 9:40 pm, Ross Peoples <[email protected]> wrote: > If I am reading this properly, you want to create a new instance if db for > each thread? I have never tried this before, but could you do something like > this for each thread? > > db_thread = DAL(db._uri) > for k, v in db.items(): > db_thread[k] = v > > The idea being to using the existing db's URI string to make a new DAL > instance, then copying the table information from db to db_thread. Again, I > don't know if this works, but it might point in the right direction unless > someone else has a more elegant solution.
Or another direction. DB is generally not designed to handle concurrency very well. So maybe Kimmo can have his script handle concurrency by gathering data into a queue, then use a 5th thread to dump data into db. Regards, Iceberg
