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 looking for, with the added
benefit of high availability.

More info at: http://www.mysql.com/products/database/cluster/

Thanks,

Jimmy Guerrero
Sr Product Manager
MySQL, Inc

> -----Original Message-----
> From: Ryan Stille [mailto:ryan@cfwebtools.com]
> Sent: Wednesday, November 08, 2006 8:22 AM
> 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
> end select queries take a second or two.
> This is all running on MSSQL, and we are wondering if we
> could find any
> speed improvements by moving to MySQL, possibly running on a
> ram disk.
> Any input appreciated.
>
> Thanks,
> -Ryan
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=jguerrero@mysql.com
>
>