Thierry Coopman writes:
> Hi,
>
> I have read on some presentation that you can create a table in
> memory that then gets written to disk once every few hours.
>
> I can't find information about that in the documentation, but it
> would be a perfect solution for me. I need 500+ updates per second,
> so a table in memory would be the most ideal. But I was wondering if
> that table can be written to disc automaticly. (Once per day schould
> be enough actually)
>
> --
> Thierry Coopman - [EMAIL PROTECTED]
> My opinions are personal, and have really nothing or nothing to do
> with Keytrade!
>
> You know that you are drinking too much coffee if:
> ... You speed walk in your sleep.
>
Hi!
You should simply use HEAP tables and make a cron job (providing you
are on Unix) to do CRE#TE TABLE ...type=MyISAM ... SELECT * from
HEAP_TABLE, every few hours or so.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php