[thelist] Updating a BIG table with a few indexes...
Tris
beertastic at gmail.com
Wed Sep 5 11:13:03 CDT 2007
ALTER TABLE table1 ADD INDEX (fieldName), ADDINDEX (fieldName) .........
with 8 million records...
On 05/09/07, Matt Warden <mwarden at gmail.com> wrote:
> On 9/5/07, Tris <beertastic at gmail.com> wrote:
> > We have 8 million records on our users table.
> >
> > We want to add 8 indexes to 7 of the 17 columns. we have 2 already...
> > to do so is taking 9+ hours...
> >
> > is there an easy (well, quick way) to change a table structure,
> > without taking so long?
>
> Definitely should not be taking that long. How exactly are you adding
> these indexes? What kind of indexes are they?
>
> --
> Matt Warden
> Cincinnati, OH, USA
> http://mattwarden.com
>
>
> This email proudly and graciously contributes to entropy.
> --
>
> * * Please support the community that supports you. * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>
--
Give a man a fish and he'll feed himself for a day.
Give a man a religion and he'll starve to death praying for a fish.
Anon
`We are what we pretend to be, so we must be careful what we pretend to be.`
Kurt Vonnegut
`When a person can no longer laugh at himself, it is time for others
to laugh at him.`
Thomas Szasz
More information about the thelist
mailing list