HTTP Streaming in VB

Question

User-154124751 posted

Hi Everyone,

 

I'm new to posting to these forums, but have found most of answers here regardless. I have no idea where to post this question, thus I picked this forum. I have a site with potentially very long running SQL queries and verification process. The user would have an idea how far along they would be by the part number currently being analyzed in the process. I've done a lot of reading and have determined that setting up a two way socket with the client would be the best way to communicate this information to the user. Are there any vb examples out there on which I could base my code?

 

Many Thanks for your consideration,

 

Marc 

Answer 1

User-525215917 posted

What is the situation? Users are waiting for queries to be completed or they go away and come back later to see how queries are progressed?

Answer 2

User-154124751 posted

Hi DigiMort,

 

Thanks for your interest. That's exactly the problem. 100s of thousands records are being compared against similar tables and the queries can potentially run a couple of hours. First, since the user is familiar with the content, I'd like to show him how far along we are by showing in my case, the part number, secondly, the users' browser normally times out making them think that the process died before it's completed.

 

Marc 

Answer 3

User-525215917 posted

In this case you should keep some information in service so you know who is the user who started the operation. To same information structure you can report the progress by long running process. When user comes to page then you can show how operation is processed this far and you can do it by simple service request without affecting the running process.

Answer 4

User-154124751 posted

Hi Mort,

 

Your suggestion is not exactly what I had in mind, but on the other hand it would certainly make the user much more productive. I'm going to restructure the program as a batch submital, and send the completed reports into the user's mailbox.

Your thoughts are greatly appreciated!

 

Marc  

Answer 5

User-525215917 posted

Well, this solution seems better to me as you don't have to track the progress actively. If those batches are running for very long time (like days or weeks) then I think it is good idea to notify user about the progress meanwhile.