Forum OpenACS Q&A: Re: SWS CR indexing stoped working - max number of extents reached in table

Correction:
it was CR_REV_CONTENT_INDEX that was so slow and not SWS as SWS does not use this index but its own sws_srch_cts_ds_iidx

I'm using Null filter and not Inso and this seemed to be the problem for CR_REV_CONTENT_INDEX as it tried to index everything including binary files generating million of rows in the index and filling up disc space. Instead SWS has a clean table for indexing containing only data you need for your search hence Null intermedia filter is working fine here.

Droped cr_rev_content_index entirely as not needed anywhere in the system and using sws ( sws_srch_cts_ds_iidx) search instead.