Re: Is "HANDLER ... CLOSE" required?
Hi,
you do not need to open and close the handler table for every read. But keeping it open prevents some other operations on the table. You should at least close and reopen from time to time.
Opening allocates some data structures and marks the table in use. Closing unmarks and releases the structures.
Regards
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
3233
March 27, 2006 01:22PM
Re: Is "HANDLER ... CLOSE" required?
1701
March 28, 2006 02:49AM
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.