Welcome Guest, Not a member yet? Register   Sign In
MySql: SQL in models vs. SQL in Stored Procedures
#2

[eluser]rogierb[/eluser]
Hi,

As for speed, don't expect any miracles. It will just be a fraction faster then the 'ol method of PHP/MySQL.

Is has benefits if you use a separate DB server. Then it will decrease traffic. Another nbenefit is if you have a large number of rows that need some kind of work. It will be faster since the large resultset doesn't have to be tranferred over the network.

I think there is an issue with access. Some vague memory of procs running under the user that nade them rather then the user that calls them. But I'm not sure whether this was with MySQL.

Hope this helps somewhat


Messages In This Thread
MySql: SQL in models vs. SQL in Stored Procedures - by El Forum - 11-10-2008, 04:15 AM
MySql: SQL in models vs. SQL in Stored Procedures - by El Forum - 11-10-2008, 07:07 AM



Theme © iAndrew 2016 - Forum software by © MyBB