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  1461 
What IF the user searches for more than one word? What do you WANT to
happen? OR the words? AND the words?
"Michael" <Mi*****@discus sions.microsoft .com> wrote in message
news:DA******** *************** ***********@mic rosoft.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*****@discus sions.microsoft .com> wrote in message
news:DA******** *************** ***********@mic rosoft.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*****@discus sions.microsoft .com> wrote in message
news:9C******** *************** ***********@mic rosoft.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*****@discus sions.microsoft .com> wrote in message
news:DA******** *************** ***********@mic rosoft.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. ?
My preference would be to use htdig, but on the htdig
site there's only a small list of hosting providers
that provide this and google doesn't help me too much
|
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 folloming table:
CREATE TABLE searchlog (
IDSearchLog MEDIUMINT UNSIGNED NOT NULL auto_increment,
F1 MEDIUMINT UNSIGNED default NULL,
F2 VARCHAR(40) default NULL,
F3a SMALLINT UNSIGNED default NULL,
|
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 developed with PHP, you are not
supposed to doubt that.
As a proof that PHP pages could be crawled and indexed, refer this
Google search
|
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 make the
design looks a bit rediculous. He also said that the big text cannot
be hidden. I am just trying to find a compromise. Here are the
questions:
(1) Is it true that a page with an <H1> tag and very big font size
will make a search...
|
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 get some good real world
examples.
Fire away! :)
Regards,
Peter Foti
| | |
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 be great if the engine (or so) would accept multiple parameters (like a search offset, a max number of bytes to search in etc.)
Any ideas
Thanks a lot again
Gordon
|
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, say, google?
I need help on this before i start coding the site. (what do newspaper
sites do?)
chow
|
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 the pages are PHP generated. Ideally, I'd like for the PHP
backend to serve up the language based a) the user's locale, and if that
is not set, its own locale.
|
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 is that stored procedure is the way to go.
What's the best way of doing this using stored procedures. Can I
define a placeholder for the field name?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
