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 |
| / / / |___| __/ ___ \ |linux@stripped |
|/_/_/|_____|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 |
| |Cel: +58-412-8859934 |
| |geek by nature - linux by choice |
|...........................................................|
