Home > mailing lists

stored proc vs sql query string - Mailing list pgsql-general

From	surabhi.ahuja
Subject	stored proc vs sql query string
Date	April 6, 2006 04:08:26
Msg-id	8626C1B7EB748940BCDD7596134632BE39866C@jal.iiitb.ac.in Whole thread Raw
Responses	Re: stored proc vs sql query string (Sean Davis <sdavis2@mail.nih.gov>)
List	pgsql-general

i have heard somewhere that writing a stored procedure, is much better than firing a sql query(such as select * from table_name) onto the database.

is it true and if yes how?

also i want to know that is the performnance in java slower as compared to cpp, given that the same things is being done.

i m using postgresql 8.0.0

thanks,

regards

Surabhi Ahuja

From: "Greg Sabino Mullane"
Date: 06 April 2006, 03:04:48
Subject: DBD::Pg version 1.48 released

From: "karthick muthu"
Date: 06 April 2006, 06:02:38
Subject: help