| Hilary Cotter 2005-03-16, 5:58 pm |
| workid is a temporary identitifier. The value of the workid changes. It is
not a good property to query on. When you query on it, it seems that it is
doing a grep of your file system.
Exactly what are you trying to accomplish.
--
Hilary Cotter
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
"Vince C." <noname@hotmail.com> wrote in message
news:Ofz1qUXKFHA.4092@tk2msftngp13.phx.gbl...
> Hi.
>
> I'm doing queries against files WorkID in Index Server using OLEDB
provider
> and a recordset. Queries are successful but are very slow to return
results.
> On my machine it seems Indexing Services are scanning something on my hard
> disk since I see (and hear) a lot of disk activity when I run the query.
The
> query is as follows:
>
> SELECT Path
> FROM System..Scope('(\"C:\\\")')
> WHERE WorkID=36195
>
> The recordset is opened as follows:
>
> var szSQL = "<select statement above>";
> var pRS = WScript.CreateObject("ADODB.Recordset");
> pRS.Open(szSQL, "Provider=MSIDXS");
>
> Do I have to do something to speed it up? Or is it by design?
>
> Thanks for any hint/suggestion.
> Vince C.
>
>
|