closing the table?

[chrish]

I am using the handler to quickly acess information off an MyISAM table.

HANDLER OPEN Test_Table;
HANDLER Test_Table READ Test_Index=('1');
HANDLER Test_Table CLOSE;

I want that MySQL isn't closing the table between commands. What does HANDLER ... CLOSE; do? Is it safe to ommit it from this operation? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Yadira]

No, do not open and close the handler table for every read. keep it open to prevent some other operations on the table. Opening allocates some data structures and marks the table in use. Closing unmarks and releases the structures. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[waqar]

i guess it should work. you are closing the table at end of query -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --