MQSeries.net :: View topic

tmnt_g · Posted: Sun Mar 16, 2008 10:59 pm Post subject: DELETE caluse in ESQL

Hi there

We're using WMB 6.0.0.5 on linux, with Oracle DB 10.0.2.2

We encounterd a serious problem while using DELETE in esql.
we wrote a DELETE clause (not too complicated) which caused a crash in our server because it parsed the statement to 30,000 DML commans every 3 seconds. The amount of DML commands that were suppose to be written was only 2000.

So we rewrite the clause using PASSTHRU, and the problem was solved.

Did anyone encounter such a beahvior before?
Do you suggest changing all our sql statments to PASSTHRU?

Thanks for your help,

Gil.