Fetch one column from one row by id

user4472042

Should a Procedure be made for a simple query??

query:

select name from posts where id = $id; ?

Whats faster in this small query. plain sql or procedure?

Any performance considerations?

Thanks Max

Christopher Jones-Oracle

What DOES matter is that you must use bind variables and never use string concatenation like 'select name from posts where id = $id;'

You will destroy scalability.

Regarding procedures, you really need to benchmark it yourself.  Your client machine, network and DB can all influence the absolute time for this.

Performance isn't the only consideration: what is easier for you to maintain or secure?

There will be an overhead going from the PL/SQL layer to the SQL layer.  Does it matter?  Maybe or maybe not.