>anyway, insert performance on myisam really beat oracle even with disable logging Of course it does! Compare MyISAM with Innodb and you'll get a similar result as MyISAM versus Oracle. MyISAM has far fewer overheads. It's also unsafe in the event of server crash, which rules out its use for pretty much any read-write production database. Andy Bryant Cambridge, UK -- The Wellcome Trust Sanger Institute is operated by Genome Research Limited, a charity registered in England with number 1021457 and a company registered in England with number 2742969, whose registered office is 215 Euston Road, London, NW1 2BE. -- //www.freelists.org/webpage/oracle-l