I have a bridge windows service application that provide service for
two applications running on Oracle and SQL server 2000 respectively.
Oracle application has trip info and SQL application has GPS Log info.
My Application read trip, compare with Log and update GPS status back
to Oracle Application. I used producer object, work queue and consumer
object. My application must execute more or less 10000 jobs in queue
within in every 2 minute interval. Here is come to question I would
like to know, Is it safe and sound if I used foreground Threads for
each job in queue? How do I design application to do in time execution
if I used thread pooling offered from .NET framework? On the other
hand, I don't want to manage execution threads that need a lot of
ManualResetEvent objects. I was wondering your scalable design patterns
for scenario like this? Thanks in advance.