Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo file too large
Message
From
08/04/2011 09:03:40
 
 
To
07/04/2011 13:55:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01506357
Message ID:
01506606
Views:
47
>>>
>>>You should look into why memo is growing so fast. Most likely it's result of to many updates on memo fields. Every time a memo field is updated, it's copied entirely to the end of FTP file (unless table is open exclusively).
>>
>>
>>I'm aware of what is causing the issue, and I have plans to address that. There's a nightly automated job that updates this table and makes thousands of updates to this memo field. I intended to remove the memo and replace it with a character field of reasonable size, since it isn't critical that the entire contents of the source field be available all the time.
>
>A better strategy would be to collect all the updates in memory and write them to the memo once. Then you can keep your history without memo bloat.
>
>Tamar

I may not have stated what's happening very clearly. The table has about 400,000 records in it. The update happens once per day to each record, if that field has changed in the source table.
Jim Newsom
IT Director, ICG Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform