|
Home > Archive > IIS Index Server > October 2006 > Index Services query results less than reported in Indexing Services
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Index Services query results less than reported in Indexing Services
|
|
|
| I used Hilary's code to select all files from my catalog.
This is basically what I used but with early binding (MS Access 2003).
=============
set ixsso=createobject("Ixsso.query")
ixsso.Catalog="web"
ixsso.Columns="FileIndex, Path, FileName"
ixsso.Query="Select FileIndex, path, Filename from Web"
set RecordSet=Ixsso.CreateRecordSet("nonSequential")
================
I should get all indexed files I think/hope.
Indexing Services reports 540,000+ files but I am only getting about 206,000
files. I even included AddScopeToQuery with "/" and "deep" which did
nothing. Why don't I get all of the indexed files?
Regards
| |
| Hilary Cotter 2006-10-28, 1:40 pm |
| There was a bug where if you did a rescan it would report the documents in
the index twice. IIRC this would be fixed on the next merge.
Can you do a check to see how many files there are in this directory.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"AC" <no@spam.me> wrote in message
news:%23HGkK0Y%23GHA.4524@TK2MSFTNGP04.phx.gbl...
>I used Hilary's code to select all files from my catalog.
>
> This is basically what I used but with early binding (MS Access 2003).
> =============
> set ixsso=createobject("Ixsso.query")
> ixsso.Catalog="web"
> ixsso.Columns="FileIndex, Path, FileName"
> ixsso.Query="Select FileIndex, path, Filename from Web"
>
> set RecordSet=Ixsso.CreateRecordSet("nonSequential")
> ================
>
> I should get all indexed files I think/hope.
>
> Indexing Services reports 540,000+ files but I am only getting about
> 206,000
> files. I even included AddScopeToQuery with "/" and "deep" which did
> nothing. Why don't I get all of the indexed files?
>
> Regards
>
>
| |
|
| There are about 1.3 million in the tree. We know we are only getting a
subset of the files and expect it. These files are a collection from hard
drives with all of the Windows and other application files. We also have
additional Ifilters such as pdf, xml, zip, ...
Thanks for the tip about the bug.
"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:u71eYNf%23GHA.4356@TK2MSFTNGP05.phx.gbl...[vbcol=seagreen]
> There was a bug where if you did a rescan it would report the documents in
> the index twice. IIRC this would be fixed on the next merge.
>
> Can you do a check to see how many files there are in this directory.
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "AC" <no@spam.me> wrote in message
> news:%23HGkK0Y%23GHA.4524@TK2MSFTNGP04.phx.gbl...
|
|
|
|
|