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 you work with it in more detail as the list will be able to help you tune your database. Atle - Flying Crocodile Inc, Unix Systems Administrator On Wed, 8 Nov 2006, Ryan Stille wrote: > 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]
