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:
1. They can help enforce data security.
2.Amount of information sent over the N/W is less
3. No compilation step is required to execute code
4. 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