8 messages in com.mysql.lists.clusterRe: Stored Procedues| From | Sent On | Attachments |
|---|---|---|
| Nick Hoffman | 21 Aug 2006 17:15 | |
| Stewart Smith | 21 Aug 2006 20:19 | |
| Benton, Kevin | 22 Aug 2006 16:46 | |
| Jason Brooke | 22 Aug 2006 17:00 | |
| Stewart Smith | 23 Aug 2006 03:15 | |
| Benton, Kevin | 23 Aug 2006 08:54 | |
| Nick Hoffman | 23 Aug 2006 16:46 | |
| Stewart Smith | 23 Aug 2006 18:03 |
| Subject: | Re: Stored Procedues |
|---|---|
| From: | Stewart Smith (stew...@mysql.com) |
| Date: | 08/21/2006 08:19:51 PM |
| List: | com.mysql.lists.cluster |
On Tue, 2006-08-22 at 10:15 +1000, Nick Hoffman wrote:
which says that stored procedures exist within a mysqld process rather than within an actual database, and that creating a stored procedure on one mysqld node will not make the SP available on any other mysqld nodes. Is this still the case?
yes.
Also, do stored procedures work any differently in Cluster? Are there specific or different performance advantages or disadvantages to using SPs in Cluster?
performance is generally greater when using SPs with any engine as the processing (done in the SP) is closer to the data (avoids network hops to the application).
So, generally speaking, using SPs will give you better performance.
-- Stewart Smith, Software Engineer MySQL AB, www.mysql.com Office: +14082136540 Ext: 6616 VoIP: 66...@sip.us.mysql.com Mobile: +61 4 3 8844 332
Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html