Discussion:
Slow performance with web query
(too old to reply)
c***@gmail.com
2008-10-15 21:36:46 UTC
Permalink
Raw Message
Hi,

I have a catalogue consisting of a single network share, comprising
about 225 thousand documents. Whenever I open the "Query the Catalog"
form in the MMC, I'm always able to query by file size and file name,
and get a pretty snappy response back. For example, if I enter:

(#filename "*.doc")

I will get:

"Query matched 555 record(s). Now showing 1 to 25."

and I will see the results almost right away.

Now, if I try to use the web interface I created, if I try the same
query, the search will take about 1 full minute to compute. I get the
same count at least (more than 300, my max records).

From doing a bit of research, I found the reason it's taking so long
to come back with the results is because I have the following flag set
to false:

CiForceUseCi=false

If I turn it to true, then yes, the performance increases, but if I
check the results I do not get the same results:

For the above query, the web query will return the following:

Documents 1 to 20 of 43 matching the query "(#filename="*.doc")".

Why only 43 documents?

How can I get it to do the same thing the MMC Query Catalog Form is
doing?

Any hints will be appreciated. thanks.
c***@gmail.com
2008-10-15 22:19:32 UTC
Permalink
Raw Message
Post by c***@gmail.com
Hi,
I have a catalogue consisting of a single network share, comprising
about 225 thousand documents. Whenever I open the "Query the Catalog"
form in the MMC, I'm always able to query by file size and file name,
(#filename "*.doc")
"Query matched 555 record(s). Now showing 1 to 25."
and I will see the results almost right away.
Now, if I try to use the web interface I created, if I try the same
query, the search will take about 1 full minute to compute. I get the
same count at least (more than 300, my max records).
From doing a bit of research, I found the reason it's taking so long
to come back with the results is because I have the following flag set
CiForceUseCi=false
If I turn it to true, then yes, the performance increases, but if I
Documents 1 to 20 of 43 matching the query "(#filename="*.doc")".
Why only 43 documents?
How can I get it to do the same thing the MMC Query Catalog Form is
doing?
Any hints will be appreciated. thanks.
grrr.. replying to myself here, but I figured this one issue out. I
should be using

(@filename "*.doc")

in my query.

Now I'm seeing an issue where searching for the file size gives me
results that do not match up to what the MMC Form gives me.

MMC Form: @size > 100000000
results: 9

Web: @size > 100000000
results: 1

Again.. if I turn on CiForceUseCi=true to false, then I do get the 9
results back but it takes FOREVER!!

I hope someone still checks this group!!

cheers.

Loading...