Help: Iterating thru ixQuery recordset hangs on movenext
- From: "Guy Hall" <guy.hall@xxxxxxxxxxxxxx>
- Date: Wed, 14 Dec 2005 11:17:18 -0000
I have created an ASP search engine for my web server that has the following
problem.
When iterating thru an ixQuery recordset the "movenext" statement can take
5-6 seconds to execute!
This only happens when the query was against a catalog that is for a remote
server, the catalog is on my web server but the directory to index is a UNC
share on a remote server some 300 miles away.
My code is using the Indexing Service Query Language as follows:
[1] Generate the ixQuery, i.e. set the query parameters including
maxresults and catalog etc.
[2] Execute the query in the form set rstQuery =
ixQuery.createrecordset("nonsequential").
[3] Iterate through the rstQuery recordset object and format the results.
As I see it the recordset object returned by the ixQuery.createrecordset
method is in the server's memory and as such there is no connection between
it (or the data within it) and the remote server.
Hence, once a recordset has been returned processing it should be the same
as if the recordset was created via a SQL query, it's just structured data.
The same query executed against a catalog that has a directory to index on
the web server itself takes 0.1 seconds.
Any ides???
Regards,
SpLiT.
.
- Prev by Date: Re: APS query form resturns no results
- Next by Date: Re: Recordset not open?
- Previous by thread: Re: APS query form resturns no results
- Next by thread: Re: Recordset not open?
- Index(es):
Relevant Pages
|
Loading
