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.