What techniques can be used to improve concurrency when using SQLite and
SQLAlchemy?
My system has two threads. One collects data and does periodic insertion and
algorithms on the data. A second thread implements a web service which might
read the data or make changes to algorithm parameters in the database. This
mostly works, but occasionally I run into a database lock. The two options I
see are:
1) make this single threaded -- but not sure how to merge the web server thread
and the data collection
2) Introduce some sort of mutex protection between the threads.
Are there any other better possibilities?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
