Solved

SQL Server full-text search website integration

Posted on 2010-09-15
2
321 Views
Last Modified: 2013-12-08
Hi Experts,

Our company is evaluating if it's possible to implement full text search on our website within certain time frame. The requirements are that search has to be performed on the database tables (6-8 tables) and files (pdf, ppt, doc; 4-5 Gb).

Some tech specs:
asp.net / framework 3.5
c#
sql server 2005
windows 2008 / IIS7

My question is how long does it usually take to implement? I know it's hard to answer precisely but +/- a week. I am getting very different estimates from contractors and not sure who to believe.

Thanks!
0
Comment
Question by:RNGAdmin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 33688480
>>The requirements are that search has to be performed on the database tables (6-8 tables) and files (pdf, ppt, doc; 4-5 Gb). <<
First of all Full-Text Search as implemented on SQL Server does not search files, but rather file types.  So if you have saved the binary data in the database then yes, you can use Full-Text Search.  I would guess at most and depending on the number of rows involved it would take me to implement Full-Text search on the database between 4-6 hours.  That does not include any time needed for application development.
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 33688483
>>I am getting very different estimates from contractors and not sure who to believe.<<
Believe the one you trust and make sure you get a document fully describing what they are going to do.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An enjoyable and seamless user experience can go a long way on an eCommerce site. While a cohesive layout and engaging copy play roles in creating a positive user experience, some sites neglect aspects that seem marginal but in actuality prove very …
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
This video teaches users how to migrate an existing Wordpress website to a new domain.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question