I am trying my hands on RoR for a dummy project and I use Mysql as my
database. For data manipulation and querying purpose, should I write
ruby code directly in active record or write a stored procedure and
invoke a call through active record?
I understand there are many advantages of stored procedures:
- They can help enforce data security.
2.Amount of information sent over the N/W is less
- No compilation step is required to execute code
- Once the procedure is present in the shared pool, retrival from
disk is not required everytime different users call the procedure i.e.
reduction in disk I/O