Re: perplexing problem....

I certainly agree that it makes a difference whether you're producing an app for internal use or for sale. If you're producing it for sale then you *must* spend whatever programming time it takes to get it right because the tradeoff decisions aren't yours to make. All the apps I work on are for internal use & it's obviously affected my viewpoint. I'm *always* able to go to the Board & ask them which they want to pay for-more hardware or more programmer time.

Jim Kennedy wrote:

> There are ways to abstract the query etc. so your programmers don't have to
> deal with bind variables directly. Too often people "write a little app"
> that goes into production and kills performance. Case in point. Worked
> with someone who was writing an import routine. The benchmark of importing
> 1,000 records took 26 minutes and pegged the CPU on the server at 100%. No
> one else could do anything else on the server (with Oracle or anything
> else). (Okay they could do other things, but boy was it slow.). We made a
> few minor changes to use bind variables and the same benchmark now took
> under 6 minutes and had peaks of 35% CPU - averaged 10% CPU. Other users
> now did not notice that the import was running. All in all it did not take
> another programmer - it ain't that complex and it made our application
> saleable. Think of it as if you are the customer - do you want to buy more
> CPU's (not always possible - there are often box limitations) just because
> the vendor thought performance was cheap by throwing more hardware at the
> problem. More hardware wouldn't have made the import run faster; it would
> have made more silmultanios users possible, difference between scalability
> and performance.
> Jim
> "Calvin Crumrine" <Calvin_Crumrine_at_dced.state.ak.us> wrote in message
> news:3BA8D870.FF6F32EA_at_dced.state.ak.us...
> >
> >
> > Thomas Kyte wrote:
> >
> > > I just "shudder". you are NOT using bind variables which is perhaps the
> single
> > > most important things ALL applications should do. That statement should
> be:
> > >
> > > begin procedure( :x, :y, :z ); end;
> > >
> > > with the strings and numbers bound to x, y, z. Your system will need
> tons less
> > > ram and lots less CPU.
> >
> > Personally, I prefer efficiency in coding/maintenance over efficiency in
> RAM and
> > CPU cycles and bind variables always seemed complicated to me. I find it
> cheaper to
> > add RAM and CPU cycles than to hire another programmer. Of course it all
> depends on
> > how you measure efficiency-I think of it in terms of budget impact. How
> can I get
> > the most work done with the smallest budget?
> >
> > I think bind variables are fine in stable apps, but not necessarily in all
> apps.
> >
Received on Wed Sep 19 2001 - 14:58:10 CDT