Oninit cdi / Archive
Talk to an expert →

Re: Does oracle table locks can effect the socket/thread handling

Posted in 2007

Topics: Performance & Tuning

Clive Eisen — — source: Usenet: comp.databases.informix

monty wrote: > hi all, > > This is very strange kind of problem which i am facing since last few > days. I have got two server running say 1st and 2nd. 1st server sends > request to the 2nd server to execute some component. so 2nd server > take that request, creates a thread in which it call correspoding > component after that does same thing for all the requests. Now 1st > server is firing so many requests one after another.In this process, > Here the complete application is written in the C++. And > everything is working fine. But now i have disabled the oracle table > level lock to increse the performance. now if 1st server is sending 50 > request some(one or more;not fixed) requests are not read by 2nd > server. and hence those requests are not processed. > Here i am unable to find out how could a DB level change can > effect the client server communication. > > Somebody please help me....it's very critical... > All together now... Have you tried UPDATE STATISTICS -- Clive

↪ replying to Clive Eisen
Obnoxio The Clown — — source: Usenet: comp.databases.informix

Clive Eisen said: > monty wrote: >> hi all, >> >> This is very strange kind of problem which i am facing since last few >> days. I have got two server running say 1st and 2nd. 1st server sends >> request to the 2nd server to execute some component. so 2nd server >> take that request, creates a thread in which it call correspoding >> component after that does same thing for all the requests. Now 1st >> server is firing so many requests one after another.In this process, >> Here the complete application is written in the C++. And >> everything is working fine. But now i have disabled the oracle table >> level lock to increse the performance. now if 1st server is sending 50 >> request some(one or more;not fixed) requests are not read by 2nd >> server. and hence those requests are not processed. >> Here i am unable to find out how could a DB level change can >> effect the client server communication. >> >> Somebody please help me....it's very critical... >> > > All together now... > > Have you tried UPDATE STATISTICS Bastard! Beat me to it. :o( -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

Glossary