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
: '[EMAIL PROTECTED]' Subject: Performance problems after record deletion. > Hi > > We got a problem with a slow database after deleting records using the > MySQL released with RedHat 7.2 (Server version 3.23.41). Here is the short > story: > > We have a table with a l

Performance problems after record deletion.

2003-01-14 Thread Gunnar Lunde
> Hi > > We got a problem with a slow database after deleting records using the > MySQL released with RedHat 7.2 (Server version 3.23.41). Here is the short > story: > > We have a table with a lot of data, at the moment there are 85 million > records in our table. We developed a script that dele