Hi,
I have not implimented a search feature yet for a web site yet and wanted to
get some advice. Most of the search tips I have seen so far only deal with
searching html files or other web files. I don't need this type of search.
All I need to do is search the products tables (description and Name fields)
and return the results. Now, I could do a query like:
Select * from products where description like @SearchWord
But I'm not sure if that would be good anough to return the results needed.
What happens if the user uses more than one word in the search string? I
think the query would have to be expanded further to support more words.
Ok, Now to the main question. How well does the Full-Text search feature of
SQL Server work? How is the performance really. I've read that its suppose to
be fast, but most of that is from MS docs, and I just want to make sure what
experiances others have had.
What are you options on this topic. Thanks for any advice.
Michael Lee 3 1440
What IF the user searches for more than one word? What do you WANT to
happen? OR the words? AND the words?
"Michael" <Mi*****@discussions.microsoft.com> wrote in message
news:DA**********************************@microsof t.com... Hi, I have not implimented a search feature yet for a web site yet and wanted to get some advice. Most of the search tips I have seen so far only deal with searching html files or other web files. I don't need this type of search. All I need to do is search the products tables (description and Name fields) and return the results. Now, I could do a query like: Select * from products where description like @SearchWord But I'm not sure if that would be good anough to return the results needed. What happens if the user uses more than one word in the search string? I think the query would have to be expanded further to support more words. Ok, Now to the main question. How well does the Full-Text search feature of SQL Server work? How is the performance really. I've read that its suppose to be fast, but most of that is from MS docs, and I just want to make sure what experiances others have had. What are you options on this topic. Thanks for any advice. Michael Lee
Hi Jeff,
I have thought about that also and would like to cover that option also. I
know I'm always trying to use more than one word during website searchs and
noticed not all sites seem to work well. I seem to recall something about
Fulltext search supported boolean searchs (and, or, ect). If I have to, I
will write the code necessary support the boolean operation, but was hoping
that Fulltext search supported this. What do you think.
Thanks for the reply.
Michael
"Jeff Dillon" wrote: What IF the user searches for more than one word? What do you WANT to happen? OR the words? AND the words?
"Michael" <Mi*****@discussions.microsoft.com> wrote in message news:DA**********************************@microsof t.com... Hi, I have not implimented a search feature yet for a web site yet and wanted to get some advice. Most of the search tips I have seen so far only deal with searching html files or other web files. I don't need this type of search. All I need to do is search the products tables (description and Name fields) and return the results. Now, I could do a query like: Select * from products where description like @SearchWord But I'm not sure if that would be good anough to return the results needed. What happens if the user uses more than one word in the search string? I think the query would have to be expanded further to support more words. Ok, Now to the main question. How well does the Full-Text search feature of SQL Server work? How is the performance really. I've read that its suppose to be fast, but most of that is from MS docs, and I just want to make sure what experiances others have had. What are you options on this topic. Thanks for any advice. Michael Lee
First, you have to decide what you want (?) and set down some rules. If you
can't describe it in English, the technology won't help.
Yes, full text can do these things.
Jeff
"Michael" <Mi*****@discussions.microsoft.com> wrote in message
news:9C**********************************@microsof t.com... Hi Jeff, I have thought about that also and would like to cover that option also. I know I'm always trying to use more than one word during website searchs and noticed not all sites seem to work well. I seem to recall something about Fulltext search supported boolean searchs (and, or, ect). If I have to, I will write the code necessary support the boolean operation, but was hoping that Fulltext search supported this. What do you think. Thanks for the reply. Michael
"Jeff Dillon" wrote:
What IF the user searches for more than one word? What do you WANT to happen? OR the words? AND the words?
"Michael" <Mi*****@discussions.microsoft.com> wrote in message news:DA**********************************@microsof t.com... > Hi, > I have not implimented a search feature yet for a web site yet and > wanted > to > get some advice. Most of the search tips I have seen so far only deal > with > searching html files or other web files. I don't need this type of > search. > All I need to do is search the products tables (description and Name > fields) > and return the results. Now, I could do a query like: > Select * from products where description like @SearchWord > But I'm not sure if that would be good anough to return the results > needed. > What happens if the user uses more than one word in the search string? > I > think the query would have to be expanded further to support more > words. > Ok, Now to the main question. How well does the Full-Text search > feature > of > SQL Server work? How is the performance really. I've read that its > suppose > to > be fast, but most of that is from MS docs, and I just want to make sure > what > experiances others have had. > What are you options on this topic. Thanks for any advice. > Michael Lee This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Eric Veltman |
last post by:
Hello everyone,
I would like to know what you typically use to add a
search engine to your sites. Do you build your own
search engines, do you use existing PHP classes,
do you use htdig, etc. ?...
|
by: Bob Bedford |
last post by:
Sorry if I post here, but I don't have access to any valuable mysql ng for
this question, ans since 99% or php programmers deal with mysql, I'm sure
I'll get an answer here.
Look at the...
|
by: R. Rajesh Jeba Anbiah |
last post by:
Q: Is PHP search engine friendly?
Q: Will search engine spiders crawl my PHP pages?
A:
Spiders should crawl anything provided they're accessible. Since,
nowadays most of the websites are been...
|
by: Petre Huile |
last post by:
I have designed a site for a client, but they have hired an internet
marketing person to incrase their search engine ranking and traffic.
He wants to put extra-large fonts on every page which will...
|
by: Peter Foti |
last post by:
Simple question... which is better to use for defining font sizes and why?
px and em seem to be the leading candidates. I know what the general answer
is going to be, but I'm hoping to ultimately...
|
by: Gordon Knote |
last post by:
Hi
can anyone tell me what's the best way to search in binary content? Best if someone could post or link me to some source code (in C/C++).
The search should be as fast as possible and it would...
|
by: robert.dondo |
last post by:
I have a site on which i want to add content on a daily basis (links
and the articles). How do I layout the site?
I could use a database but : will users be able to search the content
using,...
|
by: CptDondo |
last post by:
I have a small, embedded app that uses a webserver to serve up pages
showing status, etc.
Right now all the pages are hard-coded in English. We need to provide
multi-lingual support.
All of...
|
by: maflatoun |
last post by:
Hi,
I have a C# web app that searches my database table using the
following search parameters
Search string, criteria (< =) and the field you want to perform your
search on. My understanding...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |