Use the command Pack Password John
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Sinclair Sent: Friday, February 01, 2008 2:05 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SYS_PASSWORDS How do you pack just that table? Mike Dennis McGrath wrote: > > I'd like to know too. I pack passwords every day to prevent this > performance killer from biting me again. > > Dennis McGrath > > ------------------------------------------------------------------------ > > *From:* [email protected] [mailto:[EMAIL PROTECTED] *On Behalf Of > *John Engwer > *Sent:* Thursday, January 31, 2008 8:18 PM > *To:* RBASE-L Mailing List > *Subject:* [RBASE-L] - SYS_PASSWORDS > > One of my clients with a 7.5 database had the RB2 file expand very > quickly. Logins slowed to a snail's pace and the database became > sluggish. A reload made very little difference. After further > investigation I found that the sys_passwords table had grown to a huge > size. I then packed passwords and did another reload. After the second > reload the database shrunk from 925K to 97K. > > I am curious to know what causes the SYS_PASSWORD table to grow so > rapidly? Anyone know? I am beginning to think that I should pack > passwords every day. > > John > > ------------------------------------------------------------------------ > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.516 / Virus Database: 269.19.17/1253 - Release Date: 1/31/2008 9:09 AM >
