Re^2: Need suggestion on problem to distribute work

All Thanks for your responses.

When I say a remote server is its a freeswitch server to whome I want to send work but its takes time so I cant send more work unless that work reaches to it. I wish to handle it separately.

I connect with single database only eg I do 200 insertion + 200 times work sending to remote server due to this next bach has to wait. Wish to fork this out from main loop so that separate thread will take care of this,

Comment on Re^2: Need suggestion on problem to distribute work

Replies are listed 'Best First'.
Re^3: Need suggestion on problem to distribute work by Marshall (Canon) on Jun 18, 2020 at 02:30 UTC
I am still not understanding your application. I alluded to this before, but running 200 insertions as a single DB transaction can take about the same time as 1 or 2 single transactions. The transaction overhead is HUGE. Doing 200 insertions at once doesn't take much more time than doing just a single insertion. I am not sure that forking or threading is your answer. I now suspect that your DB code is flawed.	[reply]

Replies are listed 'Best First'.

Re^3: Need suggestion on problem to distribute work
by Marshall (Canon) on Jun 18, 2020 at 02:30 UTC

I am not sure that forking or threading is your answer. I now suspect that your DB code is flawed.

[reply]