Solved

Continuous queue

Posted on 2013-01-06
5
277 Views
Last Modified: 2013-01-11
What im trying to do is create a logging queue that i can just enqueue items to when i need to and it will process the items in order of the item been queued. basically i want to be able to call something like
queue.enque("Some Sql query")

Open in new window

and it will then process the SQL query when it has the resources to do so. What i have at the moment is:

The queue:
 Public Class SQLQueueManager
        Public Shared Sqlitems As New Queue

        Public Sub StartProcessing()
            Dim t1 As New Threading.Thread(AddressOf Process)
            t1.Start()
        End Sub

        Public Shared Sub Process()
            Do
                SyncLock Sqlitems.SyncRoot
                    If Sqlitems.Count = 0 Then

                    ElseIf Sqlitems.Count > 0 Then
                        SqlManager.ExecNonQuery(Sqlitems.Peek)
                        Sqlitems.Dequeue()
                    End If
                End SyncLock
            Loop
        End Sub

    End Class

Open in new window


Calling the enqueue:
 Public Shared Sub InsertLog(ByVal dateAndTime As String, ByVal classStr As String, ByVal methordStr As String,
                                    ByVal logType As String, ByVal message As String)
            SQLQueueManager.Sqlitems.Enqueue(
                "Insert log SET DateAndTime =NOW() ,Class ='" & classStr & "' ,Methord ='" & methordStr &
                "' ,LogType ='" & logType & "' ,Message ='" & message & "' ")
        End Sub

Open in new window


Starting the queue:

Dim sqlT As Thread = New Thread(AddressOf SQLQueueManager.Process)
sqlT.Start()

Open in new window


Im not sure if this is the best way to do this, As this is a application that is going to be constantly running and using this queue I'm not sure if it would be up to doing what i need it to do.

Thanks for your help,
Houlahan.
0
Comment
Question by:houlahan
5 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 38748880
You can use the Queue class which is builtin. Then you can start a new thread which runs in the background and monitors the queue constantly. If it finds an item in queue, it processes it otherwise it sleeps for some time.
0
 

Author Comment

by:houlahan
ID: 38749038
I'm not entirely sure what you mean, I've had a look on msdn and i don't really understand how you would initiate this queue and then keep it alive so you can constantly add things to it do you know of any good examples of this?
Thanks
0
 
LVL 83

Assisted Solution

by:CodeCruiser
CodeCruiser earned 166 total points
ID: 38749259
A queue would be just a global level (declared in a module or form level) object of class Queue. You would just access one of its methods Queue/DeQueue and use a separate thread to process it.

http://msdn.microsoft.com/en-us/library/system.collections.queue.aspx
0
 
LVL 75

Accepted Solution

by:
käµfm³d   👽 earned 167 total points
ID: 38761660
If multiple threads are going to be accessing the queue that CodeCruiser is suggesting, then you are going to want to add proper synchronization to your code since the Queue class is not thread-safe. Otherwise, if you are using .NET 4+, then you can use the ConcurrentQueue.
0
 
LVL 85

Assisted Solution

by:Mike Tomlinson
Mike Tomlinson earned 167 total points
ID: 38761703
Another similar approach would be to use a ManualResetEvent() instead of a polling loop with an embedded Sleep().  Whenever an item is queued the ManualResetEvent() could be set allowing the thread to continue and process what was added.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question