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
