Does somebody know if this thread can run SQLite queries without locking my program? Or is there another way of threading database access?
I have not tested my toolkit with SQLite, but I have used it to prevent lockups with the MySQL database plugin. In fact, I used it in a custom SMTP server for a client, where any kind of delay or lockup due to a database query would have been death. You can't keep 200 client connections waiting because 1 query is taking a few seconds, or even a few milliseconds if the MySQL plugin properly shared time with RB threads, which it doesn't. Worked perfectly. The issue is whether or not the code which accesses SQLite (your code or a plugin) does anything illegal that would crash a preemptive thread. Preemptive threads have a few more restrictions than cooperative (RB) threads in terms of what APIs they can call and what they can do. But keeping a database query from slowing or stopping the execution of your application is a good candidate for PreemptiveThreadTD. You can try it in the interpreter for free, and I would be happy to help you or answer any questions via email. Daniel L. Taylor Taylor Design Computer Consulting & Software Development [EMAIL PROTECTED] www.taylor-design.com _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
