MySQL Forums
Forum List  »  Stored Procedures

dynamically alloc cursur vs. local,gloab cursor
Posted by: Kurt Bierbaum
Date: July 25, 2016 09:02AM


I am in the process to update an Arduino sketch in order to implement the connector 1.1. for Arduino.

My questions:

There are dynamically allocated and local, global (are they local AND global or local OR global, see Chuck's sample sketch "basic_select") cursors.

1. What is the difference concerning speed and memory footprint?
2. Which one is preferred for above mySQL statements?
3. Can local, global cursors be used in at least INSERT, UPDATE and SELECT queries (I guess yes)?
4. Are there any limitations for local, global cursors for other mySQL queries?


Options: ReplyQuote

Written By
dynamically alloc cursur vs. local,gloab cursor
July 25, 2016 09:02AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.