Re: Sql request to Indexservice Win2003
From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 10/06/04
- Next message: Hilary Cotter: "Re: Not Indexing Properly"
- Previous message: Hilary Cotter: "Re: Indexing Service for Arabic"
- In reply to: hildebrandb_at_postmail.ch: "Sql request to Indexservice Win2003"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 6 Oct 2004 05:54:08 -0400
I'm not sure what you mean in your post.
Could you open up computer management? Go to a command prompt and type start
compmgmt.msc Expand the services node, and right click on Indexing Services.
Select stop. Right click again and All Tasks and Tune Performance. Then
select dedicated server. This should help with your performance problems.
Regarding your request to limit your results set. You can do this in ADO but
not ADO.Net. If you are using ADO use the MaxRecords property of the
RecordSet object. If you are using ADO.Net you will have to also use ADO and
set the MaxRecords property of the RecordSet object and then have your
DataReader consume the ADO RecordSet.
The best way to do this using .Net (if this is what you are doing), is to
use Ixsso and have your DataReader consume the recordset returned. Ixsso has
a DataReader as well.
-- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html "Kojak Hildebrand" <hildebrandb@postmail.ch> wrote in message news:ec6nvr2qEHA.556@tk2msftngp13.phx.gbl... > Dear all > Soon we'll switch from Server 2000 to 2003. Now on the tests the search is pretty slow. I think one of the problem is, cause there all results comes back. > Is there any possibility to define a max result? > Something like > Select Top 50 DocTitle, filename, characterization From Scope() > > May there is somewhere a list of list of SQL statements for the Index Service? It would help a lot. > Thanks > Beat > > ********************************************************************** > Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ > Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
- Next message: Hilary Cotter: "Re: Not Indexing Properly"
- Previous message: Hilary Cotter: "Re: Indexing Service for Arabic"
- In reply to: hildebrandb_at_postmail.ch: "Sql request to Indexservice Win2003"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
