1) Add 1 or 2 gigs of ram 2) Adjust the my.ini (or my.cnf) settings to use it
This will get your data into memory and off the disk. This will make it run an order of magnitude faster. Also, you can buy a P4 from Dell for $599. You might want to throw more hardware at the problem. ----- Original Message ----- From: "Mahdi Hajimoradi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 04, 2002 2:53 PM Subject: Making fulltext index is very slow!! | Hi | I have a Huge amounts of data imported into mysql. | My database has about 1,500,000 rows.each row has a text | field with approx 70 words in it!.Size of my .MYD is 1013MB | mysql has been starting to make fulltext index on text field since 55 hours | ago!!! | and now it dose not accomplish this job yet!! | Although my HD is not very fast(128Mb & 300MHZ) but this really takes a long | time to finish. | I've increased size of key_buffer_size and table_cache befor but it still a | long time! | Dose any body can recommend me any faster solution? | | TNX in Advance | --M. Hajimoradi | | | --------------------------------------------------------------------- | 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
