I have some questions about stored procedures.
select query inside the
stored procedure is efficent or using
select query in front end. Which is take
less time and give the result is fast or if have any other way to use
select query in efficent manner? Please help.
We are using
postgresql-9.1. I want clarify my doubts because in my office we are using select query's (Getting Results from backend) in front end for reports. Now we want to know which is better and efficent way for using select query is front end or stored procedure (back end).