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 application and the server. > > I found http://lists.mysql.com/maxdb/16680 which is very old. "MaxDB" is a completely different thing from the MySQL server. Yes, both are DBMSs supporting the language SQL, but that is about all. You cannot in any way assume that a hint regarding MaxDB is valid for the MySQL server, or vice versa. > > Can someone share stored procedures tuning practices ? I personally can't help you there - hopefully someone else will. Regards, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org