4 days! Perhaps it would be best to create a new table and transfer data to
it. When you have almost everything transferred, lock the old table, sync
the tables and then replace the old table with the new.
Just a thought...
--zak
----- Original Message -----
From: "Robert Henkel" <[EMAIL PROTECTED]>
To: "Robert Henkel" <[EMAIL PROTECTED]>; "'Joshua J. Kugler'"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 2:03 PM
Subject: RE: Having success with 20 million rows
> I take that back the word not the best shouldnt be used. I should of said
> in a perfect world we shouldnt have to add columns.
>
> -----Original Message-----
> From: Robert Henkel [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 2:56 PM
> To: 'Joshua J. Kugler'; [EMAIL PROTECTED]
> Subject: RE: Having success with 20 million rows
>
>
> Well normally its not the best to add columns after the fact if the design
> met the specs. But this is not always the case. As we all now the specs
> change about every hour.
>
> -----Original Message-----
> From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 2:49 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Having success with 20 million rows
>
>
> FOUR days!?!? THAT'S patience. But I'm glad to hear the success story.
>
> j----- k----
>
> On Wednesday 09 May 2001 11:08, David J. Potter wrote:
> > Just wanted to say that we are having success using MySql. Even though
> our
> > tables are large, over 20 million rows, selects, updates and inserts
occur
> > very fast. We use both Windows and Linux. Adding a column is the only
> > action that is slow (it took 4 days once to add a column), but that is
OK
> > since we don't change columns often. Overall MySql is turning to be a
> > great fast database. David
>
> --
> Joshua Kugler
> Associated Students of the University of Alaska Fairbanks
> Information Services Director
> [EMAIL PROTECTED]
> 907-474-7601
>
> ---------------------------------------------------------------------
> 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
>
> ---------------------------------------------------------------------
> 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
