I use myisam for reading.
I now use SQL for updating. When I used myisam for updating, tables
sometimes corrupted, and I was unable to work out why.
Currently I am changing programs to use HANDLER syntax not myisam for
reading. This will:
- Save the need for table locking.
- Allow the use of InnoDB etc.
- Allow mysqld to have full control.
I recommend you just use SQL for everything.
----- Original Message -----
From: "Stéphane Bischoff" <Stephane.Bischoff@stripped>
To: "MySQL (E-mail)" <mysql@stripped>
Sent: Friday, December 12, 2003 12:15 AM
Subject: How to READ/WRITE directly on MyISAM data files ?
I would like to know how to write directly to MyISAM files, without passing
by SELECT or UPDATE queries.
I believe this info can be found in the files myisam.h and myisammrg.h, but
I am not shure if its safe and
how to do it.
I would very much like to have an example of this code (C code).