tuning stored procedures

--00504502b4ac2e611d047d409784
Content-Type: text/plain; charset=ISO-8859-1

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

--00504502b4ac2e611d047d409784--

Re: tuning stored procedures

Ted, all,


Ted Yu wrote:
> Hi,
> We currently use SQL statements embedded in Java code. I believe st=
ored
> 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.

>=20
> 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 al=
l.

You cannot in any way assume that a hint regarding MaxDB is valid for
the MySQL server, or vice versa.

>=20
> Can someone share stored procedures tuning practices ?

I personally can't help you there - hopefully someone else will.


Regards,
Jörg

--=20
Joerg Bruehe, MySQL Build Team, Joerg.Bruehe@Sun.COM
Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB1610=
28


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg