Re: Size of fulltext catalog

Tech-Archive recommends: Fix windows errors by optimizing your registry

Ok,
but why the .ci file grows everytime I drop and recreate the same index (on
the same data)?

I create the index (the first time) and it's 50Mb, then I drop and recreate
the index and it bacomes 100Mb, then if I drop and recreate it another time,
it becomes 150Mb.... and the query performance decreases...

I have to recreate the catalog everytime?

Thanks!
Paola


"Hilary Cotter" wrote:

The catalog files are basically configuration files. Some of the files
contains words or tokens which were discovered in your last population.
These are retained despite index drops. A reorganization will merge index
files - the files ending or beginning in ci.

"paola" <paola@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4D84BA41-9046-4FF9-84B3-F65207D0F3A2@xxxxxxxxxxxxxxxx
Hi!
I'm using fulltext indexes and I can't understand what happens in the file
system.

This is my test:

1. I create the catalog:
CREATE FULLTEXT CATALOG FTC02_slave
ON FILEGROUP FG01_SLAVE
WITH ACCENT_SENSITIVITY=OFF

and SQL Server creates these folders:
\FTC02_slave
\FTC02_slave\MssearchCatalogDir

2. I create three fulltext indexes on three different tables (in the same
new catalog).
In \MssearchCatalogDir are created:
- one file .ci
- one file .dir
- one file .wid
- one file .wsb
with a total size of 54,9Mb

3. I drop the fulltext indexes:
in \MssearchCatalogDir there are no changes (total size = 54,9Mb).

4. I re-create the fulltext indexes (the same indexes, on the same tables,
on the same data). In \MssearchCatalogDir the file .ci has a double
dimension
and the total size is 102Mb.

5. I execute: ALTER FULLTEXT CATALOG FTC02_slave REORGANIZE but there are
no
changes.

6. I repeat step 3 and step 4 and now the total size di 152Mb.

7. Ad this point I drop e re-create the fulltext catalog and indexes and
the
total size
in \MssearchCatalogDir is 54,9Mb.

Why the size doubles everytime I recreate the indexes? (the query
performance - with CONTAINS or COINTAINSTABLE- decreases everytime...)

I have to recreate the catalog everytime?

Please could some one help me?
Thank you in advance!

Paola




.

Relevant Pages

  • Re: Damn you, FEDEX! or Nikon D40 lost in Springfield, MO blackhole.
    ... the 2 mp Mavica he had been using with a Nikon D40. ... After shopping around, he got me to order one for him. ... The shipper had it insured, but from what I have read it could take weeks to sort this crap out. ... You may get your insurance from FedEx and a couple weeks later they find it and deliver it. ...
    (alt.photography)
  • Exchange 2000 vs MS Serarch services
    ... catalog and rebuild the index. ... reset the catalog and rebuild the index. ... to delete and recreate the catalog. ...
    (microsoft.public.exchange.admin)
  • Word: Address Labels.. Want Postal code on separate line
    ... Everytime I change anything in the excel data source.. ... I have to recreate ... I want it on a separate line. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Size of fulltext catalog
    ... The catalog files are basically configuration files. ... I'm using fulltext indexes and I can't understand what happens in the file ... Why the size doubles everytime I recreate the indexes? ...
    (microsoft.public.sqlserver.fulltext)
  • Re: The Sci-Fi Rejection Letter That Time Forgot
    ... nations have stockpiled arsenals of these incredible bombs and the time the story is set. ...
    (rec.arts.sf.written)