January 18, 2007 at 5:40 pm
iam making a jobsite.
i am planinng to ad a keyword based search engine to my site.
but how do it ? by using like keyword
for
ex select * from joblist where jobdescription like 'Asp.net%'
jobdescription is text field
will this thing be an approiate way of doing it,
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
January 18, 2007 at 8:32 pm
dont just see, pls answer, if u didn't understand the question pls ask
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
January 19, 2007 at 8:32 am
Just to start with, no:
SELECT * FROM ... LIKE 'Asp.net%'
will only find data that is starts with Asp.net. If you want to search in the middle of a string you need:
LIKE '%Asp.net%'
That'll find it.
However, it's going to perform very slowly. You should look at full text indexing or even third party tools (google leases their technology) to get really sophisticated searches across free form text such as job descriptions & resumes.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 19, 2007 at 8:59 am
Also if you are going with your own engine do take care of indexes the appropriate columns that are used as part of your search.
Prasad Bhogadi
www.inforaise.com
January 20, 2007 at 8:10 pm
google leases there search engine technology ?
explain me more, i need some thing cheap and easy,
iam using shared hosting, do i need to buy dedicated hosting so that i can use document indexing feature
or this kind of trick will work on shared hosting as well
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
January 20, 2007 at 8:29 pm
what techniques they must be using
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
January 22, 2007 at 6:28 am
If you're going for cheap, then you just need to set up full text indexing that comes with SQL Server 2005. Otherwise, I found this information on the Google site:
http://www.google.com/enterprise/#utm_medium=et&utm_source=bizsols&utm_campaign=enterprise
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 23, 2007 at 12:33 pm
solution u provided seems to be very cool.
but its expensive.
lets see if i can use it
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
January 23, 2007 at 12:37 pm
Just an idea. Buy vs. Build always has trade-offs in either direction.
There are other text indexing products out there. Shop around.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 31, 2007 at 10:39 am
any thing free,
any free search engine coded in asp ,
becoz that seems to be lot of technical stuff,a ready to install search engine for a job website?, any thing out there
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply