Pretty much the only way you're going to find out is by giving it a shot.
:) I imagine it shouldn't take too much time to setup. Server and query
tuning is what will take most time, but I suspect it will be worth it in
the end.
Once you have your setup, it'd be worth explaining your data and how
We have an intense data process that runs every few minutes, clearing
and then loading a database with thousands of records of data, which are
then queried on from a website. The periodic load takes about 20
seconds. Some of the front end select queries take a second or two.
This is all
To: mysql@lists.mysql.com
Subject: MySQL on a ram disk?
We have an intense data process that runs every few minutes,
clearing and then loading a database with thousands of
records of data, which are then queried on from a website.
The periodic load takes about 20 seconds. Some of the front
Maybe I should just be looking at using a HEAP table?
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Depends on the value of your data, and what you might want to invest
in cluster setup (time, money) to get this done.
Another simple option from a hardware perspective might be the use of
a PCI card with RAM that serves as a Serial ATA disk. They're
relatively new on the market but they're out