How to speed up mods to large table?

2002-04-22 Thread Michael Widenius
Hi! Nick == Nick Arnett [EMAIL PROTECTED] writes: Nick I haven't been able to dig up any specific information about how to get Nick maximum performance when making changes to large tables. I have a table Nick that's close to 4 GB, which I'm altering to come up with the best trade-off Nick

How to speed up mods to large table?

2002-04-21 Thread Nick Arnett
I haven't been able to dig up any specific information about how to get maximum performance when making changes to large tables. I have a table that's close to 4 GB, which I'm altering to come up with the best trade-off between performance and speed. Dropping a column or an index seems

RE: How to speed up mods to large table?

2002-04-21 Thread Nick Arnett
-Original Message- From: Nick Arnett [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 21, 2002 3:39 PM To: [EMAIL PROTECTED] Subject: How to speed up mods to large table? I haven't been able to dig up any specific information about how to get maximum performance when making