Comments - MEMORY Storage Engine
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
I was wondering whether one can point me to any references on how to *efficiently* convert memory tables to MyISAM/Aria tables. We have cases where it is better to insert data into a Memory table, do some fast processing and then store the data on disk into a MyISAM/Aria table. Obviously, I have tried approaches where we do this on a row by row basis: create Database; create table `myisam` (...) ENGINE=MyISAM; for loop: For every row of inmemory table insert row in myisam.
etc,etc
but I am looking on something that might be a bit more efficient (speed).
Thanks for any pointers.
Take a look at How to Quickly Insert Data Into MariaDB for some pointers.