[Dbix-class] How I hate (some) DBAs

[Jon Schutz]

Let me rephrase, then:

Has your DBA profiled his Oracle set-up to demonstrate that the DBIC
database calls are such a significant component of database load that
they need to be optimised?

I'd be calling for some hard data on which a sensible decision can be made.

Regards,

-- 
Jon Schutz                        My tech notes http://notes.jschutz.net
Chief Technology Officer                        http://www.youramigo.com
YourAmigo


Ian wrote:
> > Jon
> > I don't think the DBAs concern is about the overhead of DBIC, but the
> > efficiency of the database calls. i.e he wants to ensure that the SQL is
> > optimised and indexed correctly. He does not believe he can do that when
> > DBIC is generating the SQL because he 'has no visibility' of the code.
> >
> > IMO he is doing premature optimisation in that the database is very
> > small in Oracle terms and he can always be given sight of the actual SQL
> > queries generated.
> >
> > I suppose next he will say we can't use a high level language because he
> > can't be sure that optimising compilers generate absolutely the most
> > efficient machine code!
> >
> > Regards
> > Ian
> >
> > Jon Schutz wrote:
>> >> Hi Ian,
>> >>
>> >> Have you profiled your code to demonstrate that the calls to DBIC
are an
>> >> insignificant component of the overall request cycle time, and as such
>> >> choosing a more "efficient" technology is a waste of time, effort and
>> >> money?
>> >>
>> >> I have used PL/SQL.  Dark, terrible days, those.
>> >>
>> >> Regards,
>> >>