At 09:49 AM 4/29/2009, you wrote:
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
Lin,
You can also use Merge tables so you can have 15 MyISAM tables (1
table per year). You can reference each of these tables individually like
"Fact_2005", or as a Merge table like "Fact_All" which means it sees all
the tables. A Merge table does not physically move the data, it is only a
logical construct like a View. Merge tables makes it easier to maintain
each table because it is only 1/15th the size of the large table.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
