Thanks! That's quite helpful. I'm starting to make better use of stored procedures, though wish my skills were a little more attuned in relation to my other MySQL skills.
@TAz69x stored procedures are actually pre-compiled. When you use PHP to do send a lot of query strings they have to be compiled one for one. As for stored procedures this is not needed resulting in some performance gain.
What is the speed like when comparing handling the logic with a PHP script, and having MySQL handle the logic?
I've always used PHP to handle the logic portion of scripting, but see every once in a while someone who prefers using stored procedures (or other methods).
how can i create a stored procedure with phpmyadmin?
geminitaly 5 months ago
Thanks! That's quite helpful. I'm starting to make better use of stored procedures, though wish my skills were a little more attuned in relation to my other MySQL skills.
TAz69x 1 year ago
@TAz69x stored procedures are actually pre-compiled. When you use PHP to do send a lot of query strings they have to be compiled one for one. As for stored procedures this is not needed resulting in some performance gain.
saifbechan 1 year ago
Thanks N3ddya :D
randomstring1 2 years ago
What is the speed like when comparing handling the logic with a PHP script, and having MySQL handle the logic?
I've always used PHP to handle the logic portion of scripting, but see every once in a while someone who prefers using stored procedures (or other methods).
TAz69x 2 years ago
THankz this really helped me!
XxNYCKINGxX 3 years ago