dynamically alloc cursur vs. local,gloab cursor
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
Subject
Views
Written By
Posted
dynamically alloc cursur vs. local,gloab cursor
4010
July 25, 2016 09:02AM
847
August 01, 2016 07:22AM
870
August 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.