How effective? Very effective. Actually, I am testing it, and once I
overcame a few syntax issues, it's working great. Procedures and
functions both. I havent tested triggers yet. But so far I am using
a mini-blog thing on my web site with them and I am loving the ease of
Mysql combined (finally!) with the power of sprocs.
Of course, it is beta right now, so I wouldnt stick it into anything
you need to rely on yet, but get it going and try it for yourself.
One thing to note, while the sprocs and functions work good on
Windows, connecting with some client languages (python in my case)
isnt working. Same goes for ODBC. If you use Linux, then it works
fine.
Oh, and another thing to note. If you use MySQL Query Browser to
create the procecures, it has a bug and inserts the wrong delimiters
in the drop if exists statement. That really messed me up at first.
So, remove the // and insert the $$ and it will work great.
Greg
On 7/15/05, Scott Hamm [EMAIL PROTECTED] wrote:
How effective is Stored Procedure in MySQL 5.x?
--
Power to people, Linux is here.
--
Greg Fischer
1st Byte Solutions
http://www.1stbyte.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
