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
