[eluser]obiron2[/eluser]
Hi guys,
I'm have a look see at stored procedures in MySQL.
If I am managing the front end formatting, back end business logic development and DB management, is there any benefit in using stored procedures to fetch data in the models rather than generating SQL select statements in PHP/CI.
I am wondering whether you get any significant reduction in processing overhead if you need to build a sequence of SQL statements (e.g. multi-dimensional array) because you will only be making one trip to the SQL server even though the procedure will execute many SQL selects.
Or am I just adding anohter layer of separation that makes life more complicated.
Obiron