Re: tuning stored procedures

2010-01-17 Thread Joerg Bruehe
Ted, all, Ted Yu wrote: > Hi, > We currently use SQL statements embedded in Java code. I believe stored > procedures would give us better performance. In general, this is likely, because you would (at least) save on the number of statements and the amount of data communicated between your applic

tuning stored procedures

2010-01-15 Thread Ted Yu
Hi, We currently use SQL statements embedded in Java code. I believe stored procedures would give us better performance. I found http://lists.mysql.com/maxdb/16680 which is very old. Can someone share stored procedures tuning practices ? Thanks