• Welcome to Overclockers Forums! Join us to reply in threads, receive reduced ads, and to customize your site experience!

Oracle stored procedure for simple select * query from one table?

Overclockers is supported by our readers. When you click a link to make a purchase, we may earn a commission. Learn More.

magellan

Member
Joined
Jul 20, 2002
I have a simple query that's used to populate an HTML Select from
a single query, but it's used on practically every page of a web portal.
Would there be any performance benefit to using a stored procedure
over executing the query via oci_parse, oci_execute, oci_fetch_assoc?
 
The stored procedure does indeed help with performance as it reduces overhead by being stored directly in the database and not having to be passed over the network to run the command.

For the utterly simple SELECT * FROM TABLE, that's a rather silly benefit to claim. What is far more helpful is having the query in a single location - if you have to change it later, you don't have to find hundreds of instances in your code.
 
Back