Subject: Re: 200 milions records From: Vic Cekvenich <[EMAIL PROTECTED]> === 1. Use PostgreSQL. 2. Use multi channel disk cache controller 3. Get rid of not NULL. 4. index a primary seqnecy key
It should be subsecond. Vic ddd wrote: > HI, > > I want to insert into db 200.000.000 records of type (int6,int6).. > > the structure is: > CREATE TABLE word_page ( > IDword mediumint(6) NOT NULL default '0', > IDpage mediumint(6) NOT NULL default '0', > KEY IDword (IDword) > ) TYPE=MyISAM; > > > What do you think of it,, how would be the speed after then when i > do simple select query ... for example "Select IDpage where IDword=44" > > What should I do for best performance? > > thanks > regards > _ddd > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
