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
