Timeout with full text index

From: ENIZIN (ENIZIN_at_discussions.microsoft.com)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 08:11:04 -0700

I am new to FTIs and I'm having a problem searching a text field in my
database. I have a table that contains gene sequences that can be extremely
lengthy (30K chars) so that is why I am using a text field. With that being
said, I need to search this table using a portion of a full sequence which,
can also be very large. Although I trim it to use a varchar(8000) since this
should give me what I'm looking for. My problem is I get a timeout error very
regularly when searching by sequence. I tried putting a FTI on my table that
contains the text field and still nothing has changed. Also, I'm not sure if
I should use PATINDEX, CHARINDEX, or a LIKE statement to search this data?
Neither seem to be better than the others that I can see from my testing in
this scenario.

Thanks in advance.

Relevant Pages

  • Re: Simple search across lines?
    ... > [on ignoring newlines when searching] ... > If you ignred newlines as a character, the "you\ndid" sequence above ...
    (comp.editors)
  • Re: CurrentElement->next = CurrentElement->next->next (UNDEFINED?)
    ... > searching through the list (starting form the HEAD) then finding the ... you are not accessing the same object twice. ... question about sequence points etc. ...
    (comp.lang.c)
  • Sboot to PB Protocol
    ... Hi all - for those who have been searching for the protocol between PB and ... the target system for downloads here it is: ... Sequence is: ... Host sends: ...
    (microsoft.public.windowsce.platbuilder)
  • Re: Searching in Path
    ... If you are using ixsso you should be using the util object to restrict the ... path your users are searching in. ... but what I think should work is @Path test which would then ... I shouldn't be having a problem searching on Path. ...
    (microsoft.public.inetserver.indexserver)