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
AFAIK text indices show the number of words indexed, not the number of objects. jens On Thursday, Jan 2, 2003, at 18:08 US/Eastern, Chris Muldrow wrote:
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
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Do any of the other types of indexes show how many unique values are indexed, too? Because many of my field indexes should contain identical values, and if fieldindex shows unique values as opposed to objects indexed, that could indicate another problem. On 1/2/03 7:15 PM, "Jens Vagelpohl" <jens@zope.com> wrote:
AFAIK text indices show the number of words indexed, not the number of objects.
jens
On Thursday, Jan 2, 2003, at 18:08 US/Eastern, Chris Muldrow wrote:
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
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Chris Muldrow wrote at 2003-1-2 18:08 -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? As far as I know *all* indexes show the number of entries, not the number of indexed documents in the "# objects" column of "Indexes/manage_main".
The header ("# objects) is wrong. Please file a bug report to "<http://collector.zope.org/Zope>". Dieter
On 1/3/03 2:12 PM, "Dieter Maurer" <dieter@handshake.de> wrote:
Chris Muldrow wrote at 2003-1-2 18:08 -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? As far as I know *all* indexes show the number of entries, not the number of indexed documents in the "# objects" column of "Indexes/manage_main".
The header ("# objects) is wrong. Please file a bug report to "<http://collector.zope.org/Zope>".
Dieter
So if my FieldIndex called "Category", for instance, should only contain 20 unique values for categories, but mine is showing 41,657 in that field, I should assume something has gone wrong?
participants (3)
-
Chris Muldrow -
Dieter Maurer -
Jens Vagelpohl