[Zope] Zcatalog

Chris Muldrow cmuldrow@fredericksburg.com
Thu, 02 Jan 2003 18:08:18 -0500


I'm having some Catalog weirdness, and in trying to diagnose it, I've raised
some questions. 
My catalog says it contains 41,658 records, all of them a kind of Zclass
called an FLSNewsStory that subclasses CatalogAwareness and DTML Document.
All of the indexes show either 41,657 objects indexed or 41,658 objects
indexed--all, that is, but the text index on PrincipiaSearchSource, which is
showing 212746 objects indexed. Any idea what might be going on there? (I've
only had the catalog "find" FLSNewsStories, not any other type of object)
My primary problem is very slow searches that seem to be tying up threads
until my clients lock everyone out. The searches that get tied up send the
Catalog a CreationDate value used as a range:min and PrincipiaSearchSource
terms to match.
I've got the following indices:
Basket: FieldIndex 
# of objects:
41657 
    
Category: FieldIndex
# of objects:
41658 
    
CreationDate: FieldIndex
# of objects:   
41657 
    
Locality: FieldIndex
 # of objects:   
41657 
    
NewsPageNumber: FieldIndex
# of objects:    
41657 
    
Organization: FieldIndex
# of objects:  
41657 
    
PrincipiaSearchSource: TextIndex
# of objects:   
212746 
    
Subcategories: KeywordIndex
# of objects:
41658 
    
User: FieldIndex 
# of objects:    
41657 
    
bobobase_modification_time: DateIndex
# of objects:    
41658 
    
id: FieldIndex 
  # of objects:  
41658 
    
meta_type: FieldIndex
# of objects:    
41658