On Mon, Apr 08, 2002 at 01:32:59PM +0200, 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?
We have a similar table (with a few more rows) that has about 270 million rows in it. We add 50,000 - 100,000 per day. Queries are very fast against it. As long as you have a good sized key buffer, you should be okay. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 61 days, processed 1,654,117,497 queries (311/sec. avg) --------------------------------------------------------------------- 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