Re: Managing Very Large Tables

[Victor Medina]

hi!
Chad Attermann wrote:
Hello,

I am trying to determine the best way to manage very large (MyISAM) tables, ensuring that they can be queried in reasonable amounts of time.  
------8<
Why insisting in using myIsam, and not use some table format that can 
assure you some degree of crash recovery and transacctional state like 
innodb or bdb? 150k inserts a day is a quiete important number, i don't 
think myisam is an optimal solution for such a data base structure.

Just my two cents my friends! =)

Best Regards!
--
 |...........................................................|
 |____  _____ ____   _    |Victor Medina M                   |
 |\ \ \| ____|  _ \ / \   |Linux - Java - MySQL              |
 | \ \ \  _| | |_) / _ \  |Dpto. Sistemas - Ferreteria EPA   |
 | / / / |___|  __/ ___ \ |[EMAIL PROTECTED]                  |
 |/_/_/|_____|_| /_/   \_\|Tel: +58-241-8507325 - ext. 325   |
 |                        |Cel: +58-412-8859934              |
 |                        |geek by nature - linux by choice  |
 |...........................................................|
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]