Optimize query

[cviot]

Hello,
we have an asp script to do advanced query on a catalog. We have noted
that the query was longer if we choose to order the answer by date of
write rather than filename. Does it normal ? Are there something to do
to optimize the query ? I state that we use in the script this object
Q = Server.CreateObject("ixsso.Query")
and to sort the result we use this method :
Q.SortBy = ... (Write or FileName).

Thank you and sorry for my english (i'm french)

[Hilary Cotter]

set allow enumeration =false and when you create your recordset make it
nonsequential. This will have a greater performance impact that what you
sort by.
--
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

Post by cviot
Hello,
we have an asp script to do advanced query on a catalog. We have noted
that the query was longer if we choose to order the answer by date of
write rather than filename. Does it normal ? Are there something to do
to optimize the query ? I state that we use in the script this object
Q = Server.CreateObject("ixsso.Query")
Q.SortBy = ... (Write or FileName).
Thank you and sorry for my english (i'm french)