Re: Information message : MS Search stop limit reached. The full-text query may have returned fewer rows than it should.
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Fri, 6 Oct 2006 18:57:08 -0400
Well, maybe I didn't phrase that too well. Let's try this - too many results
are being returned in your query. This could be because there are too many
hits or because your table is so huge that many of your searches will
overwhelm the search engine.
I can't recall what the upper limit of SQL 2000 Full-Text search was - IIRC
it was several hundred million which makes me think that your query possibly
returns too many results. What is your query?
--
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
<sonalip74@xxxxxxxxx> wrote in message
news:1160165099.949638.212950@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Data table has approx 5 million rows.
When u say Table is too large to be full-text indexed do you mean it is
too large to be searched based on Full-text Index ?
-SP
Hilary Cotter wrote:
Basically it means that your table is too large to be full-text indexed.
You
need to partition it to smaller tables. How large is the table you are
full-text indexing?
--
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
<sonalip74@xxxxxxxxx> wrote in message
news:1159983752.687564.149330@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
Anyone knows what this Information message means ?
Informational: MS Search stop limit reached. The full-text query may
have returned fewer rows than it should.
This message is random and same search behaves diferently on different
servers. On some servers with same data it pulls data and on some it
gives this information message and returns no rows.
We have removed complete Noise words list and process noise words on
application front.
Any guidance appreciated.
Thanks.
SP
.
- References:
- Information message : MS Search stop limit reached. The full-text query may have returned fewer rows than it should.
- From: sonalip74
- Re: Information message : MS Search stop limit reached. The full-text query may have returned fewer rows than it should.
- From: Hilary Cotter
- Re: Information message : MS Search stop limit reached. The full-text query may have returned fewer rows than it should.
- From: sonalip74
- Information message : MS Search stop limit reached. The full-text query may have returned fewer rows than it should.
- Prev by Date: Re: Information message : MS Search stop limit reached. The full-text query may have returned fewer rows than it should.
- Next by Date: what does "NEAR" operator mean?
- Previous by thread: Re: Information message : MS Search stop limit reached. The full-text query may have returned fewer rows than it should.
- Next by thread: Re: SQL Server Freetext Error: Your Search Produced to many results
- Index(es):
Relevant Pages
|
