Hi,
check the following for a description on HEAP tables.
http://www.mysql.com/documentation/mysql/commented/manual.php?section=HEAP
HEAP tables are suitable as temporary tables since they are not saved to
disk. What you can do if heap tables suite your needs is to write a script
which writes all of the records to another table.
Keep in mind that if you use HEAP tables and mysql crashes, you will loose
all the data.
Regards
Jorge
MySQL Development Team
__ ___ ____ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\____/ Mexico City, Mexico
<___/
----- Original Message -----
From: "Thierry Coopman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 5:04 AM
Subject: Tables in memory
> 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.
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
