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, >> >> _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
