|
Home > Archive > IIS Index Server > April 2005 > return results few than maxrecords
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 |
return results few than maxrecords
|
|
| Kevin Blount 2005-04-08, 5:51 pm |
| In my script I'm setting
RS.maxrecords = 200
and I get 176 results returned. In itself that's ok, but if I increase
the max to, say, 5000, I get 513 results returned. This leads me to
wonder why, if there's 513 results out therem, setting maxrecords to
200 doesn't return 200 results.
Any clues? Let me know if there's any more info you need.
Thanks
| |
| Hilary Cotter 2005-04-08, 8:48 pm |
| what is your optimizefor setting? It is probably preformance, change it
to recall.
Kevin Blount wrote:
> In my script I'm setting
>
> RS.maxrecords = 200
>
> and I get 176 results returned. In itself that's ok, but if I increase
> the max to, say, 5000, I get 513 results returned. This leads me to
> wonder why, if there's 513 results out therem, setting maxrecords to
> 200 doesn't return 200 results.
>
> Any clues? Let me know if there's any more info you need.
>
> Thanks
>
| |
| Kevin Blount 2005-04-09, 7:47 am |
| arh.. thanks. I'd not heard of this setting. My script is basically
creating using information I've discovered here in this newsgroup, and
I'd not noticed this setting before. Thanks 
| |
| Kevin Blount 2005-04-11, 5:58 pm |
| I tried using - standardRS.OptimizeFor = "recall" - in my script, but
an error was returned. Search through googlegroups for "OptimizeFor" I
didn't see any examples or coding where the search was "ADODB.recordset
based", they all appeared to be "Ixsso.query" based. Should that
matter?
My code up to the point I entered - standardRS.OptimizeFor = "recall" -
is:
' create and open connection
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.ConnectionString = "provider=msidxs;data source=" &
sCatalogSource & ";"
objConnection.Open
'fill a recordset with the standard results
Set standardRS = Server.CreateObject("ADODB.RecordSet")
standardRS.CursorLocation = 3
standardRS.maxrecords = 200
standardRS.OptimizeFor = "recall"
should this work? or is my query type incompatible?
| |
| David Lee 2005-04-13, 5:59 pm |
| There is a bug with maxresults, sorting on rank descending, and passing in
scopes to queries. The bug didn't exist in Windows 2000.
I know this is a painful thing to hear, but you could try contacting PSS and
requesting a fix.
"Kevin Blount" <kevin@questionmark.com> wrote in message
news:1113235410.081164.238510@f14g2000cwb.googlegroups.com...
>I tried using - standardRS.OptimizeFor = "recall" - in my script, but
> an error was returned. Search through googlegroups for "OptimizeFor" I
> didn't see any examples or coding where the search was "ADODB.recordset
> based", they all appeared to be "Ixsso.query" based. Should that
> matter?
>
> My code up to the point I entered - standardRS.OptimizeFor = "recall" -
> is:
> ' create and open connection
> Set objConnection = Server.CreateObject("ADODB.Connection")
> objConnection.ConnectionString = "provider=msidxs;data source=" &
> sCatalogSource & ";"
> objConnection.Open
>
> 'fill a recordset with the standard results
> Set standardRS = Server.CreateObject("ADODB.RecordSet")
> standardRS.CursorLocation = 3
> standardRS.maxrecords = 200
> standardRS.OptimizeFor = "recall"
>
> should this work? or is my query type incompatible?
>
|
|
|
|
|