Welcome, Guest. Please Login or Register.
eccoMAGIC Forums
10/22/17 at 06:59:01
Home Help Search Login Register


Pages: 1
Send Topic Print
"Unable to complete command low memory condition detected" (Popularity: 205 )
Bryanbrown18
EccoMagic Apprentice
*


I Love Ecco!

Posts: 1
Show the link to this post "Unable to complete command low memory condition detected"
06/14/17 at 09:11:45
 
I need some help in resolving a memory issue for one of my users not sure what i have to do to stop this issue without deleting items any help regarding this issue will be appreciated
Back to top
 
 
  IP Logged
Admin
Administrator
*****


I love Ecco!

Posts: 108
Show the link to this post Re: "Unable to complete command low memory condition detected"
Reply #1 - 06/14/17 at 11:15:17
 
Back to top
 
« Last Edit: 06/15/17 at 18:54:56 by Admin »  

The Administrator.
WWW   IP Logged
Admin
Administrator
*****


I love Ecco!

Posts: 108
Show the link to this post Re: "Unable to complete command low memory condition detected"
Reply #2 - 06/15/17 at 17:40:02
 

Quote:
my user has 10,769 items 14,978 view lines and 65,365 pointers : (162 free) can you give me a quick explanation on how pointers are and how to drop them down i am guessing that is the issue.

 
 
First,  with the Memory Reporter, a '*' will appear next to the limiting count.  So,  you have a * next to the pointers count,  that gives you 162 free pointers left....  
 
so, you've used up pointers,  but you only have 11k items.
 
that is about 6 pointers per item....
 
 
this is a STRUCTURAL problem with the design of your ecco database structure,
 
you're not using folders/items effectively....  wasting pointers on too many text folder per item.
 
 
Some solutions:
 
can you use numeric or pulldown folders instead of text folders.  For example,  State and Zip can be pulldown and numeric instead of text folders.  (see example file here: http://forums.eccoMAGIC.com/forum/YaBB.pl?num=1166763739/1#1 )
 
can you combine text folders...  a LARGE text folder with 34k of text uses 1 pointer.   A text folder with only 1 character uses 1 pointer.    Ahhhh.   (ps: Control+Enter will add line in-between text when entering text column values...)
 
Can you use subitems to hold info instead of multi-text folders.  (ps: Shift+Enter will add lines in-between text when entering item text...)
 
Have you tried MagicView to hold all text data for item ?
 
or...
 
Use the slang-extension and use 'Extended Text' folders which allow many more than 65k text folders if not much text in them...    If you use the slang extension, you will likely find, your pointers do down to 11K....  which is probably your best solution.. maybe...
 
 
Ecco will hold up to 64k items.     11k items is about 80% empty, item wise...   but you can only use 64k text folders.  So you must limit # of text folders PER ITEM.    
 
 
also note:   sqlNotes  (infoqube.biz) does not have the 64k limitations,  you might look at it.
 
 
hope helpful.  
 Smiley
Back to top
 
« Last Edit: 06/15/17 at 19:18:32 by Admin »  

The Administrator.
WWW   IP Logged
Pages: 1
Send Topic Print