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

Reply via email to