MySQL Forums :: Stored Procedures :: dynamically alloc cursur vs. local,gloab cursor


Advanced Search

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

Hi,

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?

Thanks,
Kurt

Options: ReplyQuote


Subject Views Written By Posted
dynamically alloc cursur vs. local,gloab cursor 2611 Kurt Bierbaum 07/25/2016 09:02AM
Re: dynamically alloc cursur vs. local,gloab cursor 310 Chuck Bell 08/01/2016 07:22AM
Re: dynamically alloc cursur vs. local,gloab cursor 264 Rick James 08/02/2016 06:38PM


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.