[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