[thelist] MySQL Speed Question

MarsHall evolt at marsorange.com
Wed Dec 4 13:18:13 CST 2002

On Wednesday, Dec 4, 2002, at 11:18 US/Central, Ditty, Christopher J -
Memphis, TN wrote:
> My friend suggested using a temp table, dropping the production table
> and then renaming the temp table to the production name.  Other than
> the fact that the site is down for a minute, why should I not consider
> using this method?

If you do this table-swap within a script or program, the table would
"drop" for less than a second. On a relatively low traffic site, I
don't see that causing any real problems.

Mars :)

More information about the thelist mailing list