Yep... im using fulltext indexes That is, multiple indexing would be the best.
Nut now i add more memory and do some fine-tuning on my.cnf, perhaps the result won't be the same. "Me fail English? That's unpossible" ###___Archon___### ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, July 18, 2003 11:42 AM Subject: Re: Faster reindexing > umm say i reindex after a reimport i usually drop all the indexes first , > then add indexes again one by one , seems to be quicker for me especially > for fulltext indexes , doing it at once tends to be slower, must crunch the > cpu a bit dont know > > > On Wed, Jul 09, 2003 at 11:51:01PM -0500, Paul DuBois wrote: > >> At 14:14 +0700 7/9/03, Dominicus Donny wrote: > >> >Sorry, my mistake. It's "reindexing" then. > >> >Once i should add 2 key indexes on a huge table. > >> >But instead of alter the table in 1 single query, > >> >I build each index 1 by 1. > >> > >> Generally, it is faster to build all your indexes with a single > >> ALTER TABLE statement than to build them one by one with separate > >> ALTER TABLE statements. > > > > Single. > > -- > > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > > > MySQL 4.0.13: up 8 days, processed 247,399,591 queries (350/sec. avg) > > > > -- > > 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]
