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
Hello,
Depending on the characteristics of the data and baring dependencies on
specific features like FKs or complex JOINs, you may want to take a look at
MySQL Cluster.
MySQL Cluster supports in-memory and disk-based databases. So, it may give
you the high-performance characteristics you are
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