Re: Direct Access to Memory Tables

[Ingo Strüwing]

I suspect that hp_test1 hasn't been looked at since long. It simply doesn't work any more. if you file a bug report on bugs.mysql.com, it should eventually be fixed one day.

But I doubt that it would be very useful for you. Since you probably want to access the table with SELECT commands, you cannot just insert arbitrary records. You need to know the exact record layout and create a before and after image for heap_update(). Also you should better do proper table locking unless you are sure that you always run single threaded.

This all would be a major effort if you are not familiar with MySQL sources and debugging.

Another way to optimize your application might be to use prepared statements, though I don't know if they can be used with embedded servers.