MySQL Forums
Forum List  »  Memory Storage Engine

Re: Direct Access to Memory Tables
Posted by: Ingo Strüwing
Date: September 22, 2005 01:57AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
7137
September 21, 2005 12:16PM
Re: Direct Access to Memory Tables
3795
September 22, 2005 01:57AM
3551
September 22, 2005 08:03AM
3877
September 23, 2005 04:36AM


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.