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:[EMAIL PROTECTED] > 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]