in reply to Re^2: Store Procedure or Perl program?
in thread Store Procedure or Perl program?

Not very often. I highly recommend tuning the stored procedure rather than moving the entire data set into your app.

Jason L. Froebe

Help find a cure for breast cancer! Net proceeds benefit the Susan G. Komen Breast Cancer Foundation and the National Philanthropic Trust. Help by donating - I'm walking 60 miles in 3 days in August 2007. (The day I return from TechWave is the first day of the Walk).

Blog, Tech Blog

Replies are listed 'Best First'.
Re^4: Store Procedure or Perl program?
by MelaOS (Beadle) on Aug 15, 2007 at 06:33 UTC
    Hi, I agree, stored proc and the database are well optimized to handle this. Rather than exporting the work to perl which is cumbersome and slower in performance. thanks.