List:General Discussion« Previous MessageNext Message »
From:Victor Medina Date:March 30 2004 5:51pm
Subject:Re: Managing Very Large Tables
View as plain text  
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  |
  |...........................................................|
Thread
Managing Very Large TablesChad Attermann30 Mar
  • Re: Managing Very Large TablesVictor Medina30 Mar
  • RE: Managing Very Large TablesDathan Vance Pattishall30 Mar
    • RE: Managing Very Large TablesKeith C. Ivey30 Mar
    • Re: Managing Very Large TablesJeremy Zawodny30 Mar
RE: Managing Very Large TablesHenrik Schröder30 Mar