Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Continuous queue

Posted on 2013-01-06
5
Medium Priority
?
295 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 498 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 501 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 86

Assisted Solution

by:Mike Tomlinson
Mike Tomlinson earned 501 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Loops Section Overview
Suggested Courses

916 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