Re: please give examples of where using cdbi to produce comlex report queries is truly a bad idea

[prev] [thread] [next] [Date index for 2005/03/06]

On Sun, Mar 06, 2005 at 01:09:43PM -0600, .--- .- -- . ... wrote:
> Of course, my notion of a "report" may be a little different, since
> our database is so hyper-normalized that  to get any data point
> requires traversing a minimum of 3-4 tables, this makes most queries
> "report-esque'" (ie uses aggregate functions, groupings, etc).  I
> pretty much consider every screen in our application a "report".

Have you considered Class::DBI::View?

        -- 
            Matt S Trout            Brag sheet:    http://trout.me.uk/services.html
LAMP, Infrastructure        Contact:       services@xxxxx.xx.xx
   and Automation
     specialist                                       Do it once. Do it right.