howachen@gmail.com wrote:
> hi,
>
> we all know that memory table has a better performance as the data are
> stored in memory completely, however, when server was down, the data
> will be lost.
>
> are there any techniques that the original data is stored in MyISAM
> table or InnoDB, but when server bootup, the data will be write to a
> memory table automatically so that query can perform against the memory
> table? something like replication between two tables.
>
>
> thanks...
>

Are you actually having performance problems? Or are you looking for a
problems which doesn't exist?

I've found that using memory tables are more efficient - but if the
server is that loaded you have other problems.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================