Solved

Continuous queue

Posted on 2013-01-06
5
267 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 74

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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
GridDataView 6 44
Merging PDFs with VB.NET 10 31
Change data in datatable 8 15
Closing all open child forms. 4 23
Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

706 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now