Re: Store Procedure or Perl program?

A number of questions for the original poster:

Not exactly sure why you're trying to reinvent the wheel here. Can you elaborate a bit more?

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).

Comment on Re: Store Procedure or Perl program?

Replies are listed 'Best First'.
Re^2: Store Procedure or Perl program? by pysome (Scribe) on Aug 10, 2007 at 02:23 UTC
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?	[reply]
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]