Request for Assistance

[Derek Martin]

Hi there, I have a program that I am trying to deploy that checks a DB for
messages to a client every 15 seconds or so. If it finds one, it does some
stuff, then updates it in the DB as 'ACK.' I can't make it work for the
life of me and was wondering if someone would be so kind as to take a peak
at my code to offer some suggestions on 'best practice' for this type of
thing.

I am not averse to dumping the DB idea and going with some kind of port
listening, but just in general I need to be able to put a message somewhere
for a client that is then read in a sleeper process (without interupting the
rest of the program) and do stuff with that message.

Would someone be so kind? I don't want to attach the full source code of
the project here (30,000 ish lines), so if you could assist, just message
me.

Thanks!

Derek Martin

[EricJ]

I'm afraid you aren't giving enough info here :/

w DB, how do you access it ...
Im not promesing much but if you send it over (w db if it's sql server or
some file ) i'll try to have a look at it tonight

just remove the rem stuff from my e-mail

eric

"Derek Martin" <dm*****@DONTSPAMMEokstate.edu> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

Hi there, I have a program that I am trying to deploy that checks a DB for
messages to a client every 15 seconds or so. If it finds one, it does some stuff, then updates it in the DB as 'ACK.' I can't make it work for the
life of me and was wondering if someone would be so kind as to take a peak
at my code to offer some suggestions on 'best practice' for this type of
thing.

I am not averse to dumping the DB idea and going with some kind of port
listening, but just in general I need to be able to put a message somewhere for a client that is then read in a sleeper process (without interupting the rest of the program) and do stuff with that message.

Would someone be so kind? I don't want to attach the full source code of
the project here (30,000 ish lines), so if you could assist, just message
me.

Thanks!

Derek Martin

[Cor Ligthert]

Hi EricJ,

Please keep in normal situations the conversations in the newsgroup?

Cor

[Cor Ligthert]

Hi Derek,

Describing your problem as you do, is I think more important than let us
look at your code in my opinion.

What you describe does sounds for me very much as multithreading process and
also a process that uses a timer, are you doing that?

Cor

[AlexS]

Hi, Derek

first glimpse says me you are using one connection object between threads.
That's most likely reason for erratic behavior - whatever you have. I did
not look much further, though. You should have separate connection for each
thread - including UI.

HTH
Alex

"Derek Martin" <dm*****@DONTSPAMMEokstate.edu> wrote in message
news:uo**************@TK2MSFTNGP09.phx.gbl...

Hi Cor, thanks for your message. I didn't include my source code originally because of security concerns and was just looking for someone who would
volunteer off list to take a peak. However, after rethinking that, I
abstracted all the relevant stuff out as its own project and attached the
ZIP file of it here.

I don't use a timer in this example, perhaps I should! Could you and/or
anyone else take a peak and offer a way for this to work in a more logical
and functional manner?

Forgive the code organization - it was a quick abstraction!

Derek
"Cor Ligthert" <no**********@planet.nl> wrote in message
news:OZ**************@tk2msftngp13.phx.gbl...

Hi Derek,

Describing your problem as you do, is I think more important than let us
look at your code in my opinion.

What you describe does sounds for me very much as multithreading process

and

also a process that uses a timer, are you doing that?

Cor

[Cor Ligthert]

Hi Derek,

Today I am not anymore in the opurtunity to look deeply at your code.

However it seems to me that you create an extra thread only to let it wait.
That is not necessary, to let the main thread wait without a timer is

threading.thread.sleep(15000) '

I think with knowing this a lot of things are easier, however that was the
part I did stop with checking your program.

When you want help, and not someone else did it already, message it than
again OK?
The day after tomorrow I have more time.

Cor

[Derek Martin]

Thank you both for your posts! I don't understand what you are suggesting,
however.

Perhaps I should use a timer instead of a seperate thread? Also, I see that
I should use a seperate connection for each thread, that is easy enough to
do.

Which would yield better and more efficient results?

"Derek Martin" <dm*****@DONTSPAMMEokstate.edu> wrote in message
news:uo**************@TK2MSFTNGP09.phx.gbl...

Hi Cor, thanks for your message. I didn't include my source code originally because of security concerns and was just looking for someone who would
volunteer off list to take a peak. However, after rethinking that, I
abstracted all the relevant stuff out as its own project and attached the
ZIP file of it here.

I don't use a timer in this example, perhaps I should! Could you and/or
anyone else take a peak and offer a way for this to work in a more logical
and functional manner?

Forgive the code organization - it was a quick abstraction!

Derek
"Cor Ligthert" <no**********@planet.nl> wrote in message
news:OZ**************@tk2msftngp13.phx.gbl...

Hi Derek,

Describing your problem as you do, is I think more important than let us
look at your code in my opinion.

What you describe does sounds for me very much as multithreading process

and

also a process that uses a timer, are you doing that?

Cor

[EricJ]

i know but didn't have the time yesterday and it seemed like a lot so ... :p
(+i don't have the newsgroup at home, thats all on my pc at work)

summary of w i said in mail
the nature of the problem lies more in the logical flow of the problem.
i fear it can never work like this becouse you will never know how long a
user keeps one of those messages open.
--> pick up on the event handlers of the messageprocessorclass (add a new
one on a timer/sleep if needed) and only show the next message when the
current one is dealth w

i think derek can try this and if he has more problems he can ask specific
questions now. (time will tell ;p)

eric
"Cor Ligthert" <no**********@planet.nl> wrote in message
news:u0**************@TK2MSFTNGP11.phx.gbl...

Hi EricJ,

Please keep in normal situations the conversations in the newsgroup?

Cor

[Cor Ligthert]

Hi Derek,

What I would do when I was you was trying to simplify some parts first to
create a good program flow.

I cannot test your program, however I thought I could a 4 or 5 deep
procedure call including thread, bring back to this, while that would in my
opinion should give no problems.

Private Sub main_Load(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
Do While True
process_client_messages()
Thread.CurrentThread.Sleep(15000)
Loop
End Sub

Cor