dbTalk Databases Forums  

Formatted memo causes CPU to 100%

comp.databases.paradox comp.databases.paradox


Discuss Formatted memo causes CPU to 100% in the comp.databases.paradox forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jim Moseley
 
Posts: n/a

Default Formatted memo causes CPU to 100% - 11-21-2008 , 12:13 AM







Greetings all.

I've now run into this issue twice in a year, so it's an epidemic! There
are several formatted memo fields on a table. Twice now, when a user is
trying to view or edit one of those fields, the system slows to a crawl &
the CPU jumps to 100% for a minute or longer. Eventually, it returns to
normal.

What I have determined is that somehow the formatted memo field's value is
corrupt, causing this behavior. To fix this, the entire value must be deleted
& then reentered. I even got a strange Pdox message today 'internal catalog
size exceeded', which got no hits on Google.

Does this sound 'normal'? Any ideas on the cause? Also, any good ideas
on how to programmatically check all records to see if any other rogue values
exist?

Thanks,
Jim Moseley

Reply With Quote
  #2  
Old   
Steven Green
 
Posts: n/a

Default Re: Formatted memo causes CPU to 100% - 11-21-2008 , 06:18 AM






Quote:
What I have determined is that somehow the formatted memo field's value is
corrupt, causing this behavior.
that is why using memo fields is so risky.. the repair tools can't test
them, because there's no way to know what the contents are..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards




Reply With Quote
  #3  
Old   
Steven Green
 
Posts: n/a

Default Re: Formatted memo causes CPU to 100% - 11-21-2008 , 06:18 AM



Quote:
What I have determined is that somehow the formatted memo field's value is
corrupt, causing this behavior.
that is why using memo fields is so risky.. the repair tools can't test
them, because there's no way to know what the contents are..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards




Reply With Quote
  #4  
Old   
Steven Green
 
Posts: n/a

Default Re: Formatted memo causes CPU to 100% - 11-21-2008 , 06:18 AM



Quote:
What I have determined is that somehow the formatted memo field's value is
corrupt, causing this behavior.
that is why using memo fields is so risky.. the repair tools can't test
them, because there's no way to know what the contents are..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards




Reply With Quote
  #5  
Old   
Steven Green
 
Posts: n/a

Default Re: Formatted memo causes CPU to 100% - 11-21-2008 , 06:18 AM



Quote:
What I have determined is that somehow the formatted memo field's value is
corrupt, causing this behavior.
that is why using memo fields is so risky.. the repair tools can't test
them, because there's no way to know what the contents are..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards




Reply With Quote
  #6  
Old   
Steven Green
 
Posts: n/a

Default Re: Formatted memo causes CPU to 100% - 11-21-2008 , 06:18 AM



Quote:
What I have determined is that somehow the formatted memo field's value is
corrupt, causing this behavior.
that is why using memo fields is so risky.. the repair tools can't test
them, because there's no way to know what the contents are..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards




Reply With Quote
  #7  
Old   
Steven Green
 
Posts: n/a

Default Re: Formatted memo causes CPU to 100% - 11-21-2008 , 06:18 AM



Quote:
What I have determined is that somehow the formatted memo field's value is
corrupt, causing this behavior.
that is why using memo fields is so risky.. the repair tools can't test
them, because there's no way to know what the contents are..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards




Reply With Quote
  #8  
Old   
Steven Green
 
Posts: n/a

Default Re: Formatted memo causes CPU to 100% - 11-21-2008 , 06:18 AM



Quote:
What I have determined is that somehow the formatted memo field's value is
corrupt, causing this behavior.
that is why using memo fields is so risky.. the repair tools can't test
them, because there's no way to know what the contents are..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.