Lin, I've had mixes results but you might have better success. As John mentioned, there are a couple factors that you need to take into account.
How much data are you talking about (physical size and number of rows). I know you say 15 years of data but is that 100's of millions of rows? Give you more information and we can probably give you a better answer. Maybe a table structure and numbers behind it would be nice. Gary ________________________________________ From: Lin Chun [franks1...@gmail.com] Sent: Wednesday, April 29, 2009 7:49 AM To: mysql@lists.mysql.com Subject: Partition of Mysql Hi I have a table that stores huge rows in 15 years, now we have to do some analysis about these row in Time dimension.To gain performance,at begining, i've extrait the data according to years from my DB to build my fact table. But since I have 15 fact tables, that complicate my olap cube.Today, i found that mysql surpport partition table since 5.1, i wanna know is it work well ? I mean that is it more efficace than table with-out partitions? I don't want to transformer the data again, as it takes too much time, is it possible to just alter my orignal table to add the partitions by years, excuse my poor english writing and thank you for your answers -- ------------------------- Lin Chun -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org