Jim Kennedy schrieb:
> "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message
> news:dsvecd$m5v$1_at_nntp.fujitsu-siemens.com...
>> jlaffer schrieb:
>>> Thats true.. i generate it automatically.
>>> Unfortunately all these subqueries have to be configured first (in
>>> worst case for every single Attribute of my Object)
>> What do you mean by configuring first?
>> If you want to do all that bind variable stuff, forget it for that
>> kind of query. Every query is different anyway and binds make lots
>> more sense for mass inserts.
>
> You are very wrong here. Read the application developer's guide.
> Use binds or your application won't scale at all.
> Not using binds means you are
> using excessive CPU and excessive latching. (a latch is alow level lock)
Yes, but before you blindly repeat a mantra, please try to quantify that
effect. Since almost each query will be different, parsing has to be done
anyway, right? And how often per second, if a user sits in front of his
editor? How often will a query be reused? Once? Twice?
I mean if we were talking about the Lufthansa booking system here, yes,
it might make sense to make that effort, but in that case the OT wouldn't
have had to ask here.
Lots of Greetings!
Volker
Received on Thu Feb 16 2006 - 07:45:04 CST
