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]

Reply via email to