• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.