MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Thoughts on partitioning by hour - and which partition type?
Posted by: Harsh Deshpande
Date: June 06, 2008 12:53PM

Hi Adrian

I am trying to develop a similar application but I am also doing the partitioning (but by month). I was wondering what prompted you to use InnoDB storage engine. According to the whitepaper(http://www.mysql.com/why-mysql/white-papers/mysql_wp_data_warehousing.php), InnoDB has high cost of storage and slow dataload speed. It suggests MyISAM or ARCHIVE storage engine.

Harsh

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.