Re^2: Store Procedure or Perl program?

1.I wanna to lighten the MSSQL task.Since so many stored procedure have run in DB SERVER already. 2.Control all my DB operation in one server. I just want to "translated" the stored procedure into Perl program now.Is it feasible?

Comment on Re^2: Store Procedure or Perl program?

Replies are listed 'Best First'.
Re^3: Store Procedure or Perl program? by jfroebe (Parson) on Aug 14, 2007 at 15:53 UTC
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	[reply]
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.	[reply]