Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Using FullText Search for file names

  
   Database Forums (Home) -> Full Text RSS
Next:  hdmi op dvi kabels hdmi kabels real belkin hdmi k..  
Author Message
unique4

External


Since: Aug 07, 2008
Posts: 2



(Msg. 1) Posted: Thu Aug 07, 2008 5:25 am
Post subject: Using FullText Search for file names
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)
Hello,

I have an SQL Server 2005 database storing file names (millions), and I
currently use LIKE to search the database - most of the time I need to do
searches using a part of the file name. The search is very slow right now.

Will using a FullText index help with performance in this particular
situation? I mean the file names are not really full words in English, so I'm
not sure if this is the right approach.

Thank you

 >> Stay informed about: Using FullText Search for file names 
Back to top
Login to vote
Hilary Cotter3

External


Since: Aug 28, 2004
Posts: 1259



(Msg. 2) Posted: Fri Aug 08, 2008 5:43 am
Post subject: Re: Using FullText Search for file names [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
If you want to search on file extenstions, file names (ie the Document1 in
document1.doc), or wildcard is 'Doc*' yes, fts will work great for you.

If you want to search for tokens in the middle, ie ment in document, it
won't work at all.

"unique4" wrote in message

> Hello,
>
> I have an SQL Server 2005 database storing file names (millions), and I
> currently use LIKE to search the database - most of the time I need to do
> searches using a part of the file name. The search is very slow right now.
>
> Will using a FullText index help with performance in this particular
> situation? I mean the file names are not really full words in English, so
> I'm
> not sure if this is the right approach.
>
> Thank you
>

 >> Stay informed about: Using FullText Search for file names 
Back to top
Login to vote
sql411nospamcom

External


Since: Apr 19, 2007
Posts: 11



(Msg. 3) Posted: Tue Aug 12, 2008 2:55 pm
Post subject: RE: Using FullText Search for file names [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Searching for part of the filename will work with fulltext, as long as your
wildcard is at the end of the phrase and not the beginning.

If you filename is 'myfilenameisthis.doc' and you do a search like:

select *
from table
where contains(filename, 'myfilename*')

then it should work, but this won't:
select *
from table
where contains(filename, '*myfilename')
 >> Stay informed about: Using FullText Search for file names 
Back to top
Login to vote
unique4

External


Since: Aug 07, 2008
Posts: 2



(Msg. 4) Posted: Fri Aug 15, 2008 2:00 am
Post subject: RE: Using FullText Search for file names [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
As far as I know, this limitation applies when using LIKE with a normal
index on a string-type column: queries with wildcards at the end benefit from
the index, those starting with wildcards do not benefit (full table scan).

Are you sure this applies to FullText as well?

Thanks
 >> Stay informed about: Using FullText Search for file names 
Back to top
Login to vote
Daniel Crichton

External


Since: Apr 21, 2006
Posts: 74



(Msg. 5) Posted: Mon Aug 18, 2008 1:45 pm
Post subject: Re: Using FullText Search for file names [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
unique4 wrote on Fri, 15 Aug 2008 02:00:03 -0700:


> As far as I know, this limitation applies when using LIKE with a normal
> index on a string-type column: queries with wildcards at the end
> benefit from the index, those starting with wildcards do not benefit
> (full table scan).

> Are you sure this applies to FullText as well?

> Thanks

Check the Books Online - FTS only handles a wildcard at the end, as already
stated.

--
Dan
 >> Stay informed about: Using FullText Search for file names 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
FullText Search - Okay, I believe I am missing something crucial to fulltext searching. We are looking at ways to change a search from using "like" to "contains" in hopes of improving search performance on a table. We have a fulltext index on a last...

how to optimize our fulltext search - configuration hardware: cpu 4*1.5G RAM 2G software: windows 2000 server,sql server 2000 data: records >40 million ,spaceused > 14G fulltext variables: Number of items:>10 million,Number of Keys >1 million ,spaceused of Catalogue >500MB N...

application of fulltext search - Hello, It is possible to search text in my blog use a query sentence instead of several key words? Which I mean, if I want to get to know "How rich is Bill Gates?", I can simply enter this sentence instead of enter "Bill+Gates+rich+how&...

Fulltext search too slow - Hi, I am using an FT index on a column (varchar(4000) with an average length of 100) in a table that contains about 1 million rows. My tiny performance test looks like declare @t datetime set @t = getdate() select count(*) from..

Fulltext search "IT manager" - i remove "IT" from noise word and rebuild fulltext and when i query it won't give error message anymore "Informational: The full-text search condition contained noise word(s)." but it return no result any clue? SELECT top 10 j.pos...
   Database Forums (Home) -> Full Text All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]