RE: Performance problems after record deletion.

2003-01-14 Thread Vikash K Agarwal
nething. BUT wud require space and some time. vikash -Original Message- From: Gunnar Lunde [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 5:17 PM To: '[EMAIL PROTECTED]' Subject: RE: Performance problems after record deletion. Thank you for your reply, Vikash We have d

RE: Performance problems after record deletion.

2003-01-14 Thread Gunnar Lunde
To: 'Gunnar Lunde'; [EMAIL PROTECTED] > Subject: RE: Performance problems after record deletion. > > > This is what MYSQL manual 3.23.41 says, may be it helps you > > OPTIMIZE TABLE should be used if you have deleted a large part of a > table or if you have made m

RE: Performance problems after record deletion.

2003-01-14 Thread Vikash K Agarwal
This is what MYSQL manual 3.23.41 says, may be it helps you OPTIMIZE TABLE should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows (tables that have VARCHAR, BLOB, or TEXT columns). Deleted records are maintained in a linked