> Put as much memory in the machine as possible. Building indexes for a > table > of that size will consume a lot of memory and if you don't have enough > memory, building the index will be done on the hard disk where it is 100x > slower. I've had 100M row tables without too much problem. However when I > tried 500M rows the indexes could not be built (took days) because I too > little RAM.
thanks.... would you please be more specific about "to little RAM"? what amount of memory is enough for the 500M? what about search speeds? cpu? also what kind of tables did you use? thanks.... > > Mike > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
