Do you have parallel I/O or are you using Windows or Unix?
Uma Krishnan wrote:
How about when you need to take advantage of parallel I/O etc, or you need to access multiple SQLite databases w/i a transaction?
Are you dissuading thread usage from DB application point of view, or even
within SQLite kernel?
Thanks in advance
- Uma
John Stanton <[EMAIL PROTECTED]> wrote: One of the ignored points about thread usage is just how expensive are
the synchronization mechanisms. It is a good idea to apply Occam's
Razor to your design and eliminate unnecessary features and have a
result which provides a better level of functionality and a structure
which is much simpler to prove correct.
I see situations where there is a complex web of worker threads etc
applied to what would otherwise be a simple problem. The result runs
slowly and has hidden race conditions and other defects. DRH's
reservations about threads come to mind.
Applications run best when they can be reduced to a single stream
without any synchronization requirements.
Threads are indispensible when multiplexing a user interface but are
very dispensible when handling a single resource like a database.
Joe Wilson wrote:
--- Ken wrote:
In general I'v found that Thread cancellation is very painful,
a simpler paradigm to utilize is the lock timeout with a Global
variable status check.
Rather than check a global variable you could simply pass a null
event to the queue which instructs the thread to simply to finish
(a.k.a. return) gracefully. That way you can avoid the lock timeout
and polling.
On the GUI thread, however a timeout and poll may be necessary
depending on the framework.
____________________________________________________________________________________
Be a better pen pal.
Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------