Yes, read up on HEAP tables in the manual. You have read the manual? Here is a quick
rundown. Create HEAP table and read all data into table on startup. When you do an
update, do it on HEAP table and to the database on disk. Both should then be in sync.
This assumes you don't do many updates.
--
Richard Ellerbrock
[EMAIL PROTECTED]
>>> "Johan Geuze" <[EMAIL PROTECTED]> 2001/01/23 02:39:04 >>>
Hello,
I've got a mysql database(3.23) on a very slow disk, the database is only
50mb in size but the harddisk seems to be the real bottleneck here.
The linux box where mysql is running on has 640 megabytes of ram. the
database would fit into the ram with no problems.
Is there an option to have your entire db in ram, (constantly updating the
slower db on disk)?
I know this gives dataloss if a powerout happens.. but this isn't a issue
really.
regards
Johan Geuze
---------------------------------------------------------------------
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
