[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL Server full-text search website integration

Posted on 2010-09-15
2
Medium Priority
?
329 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
  • 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 2000 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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

When the s#!t hits the fan, you don’t have time to look up who’s on call, draft emails, call collaborators, or send text messages. An instant chat window is definitely the way to go, especially one like HipChat. HipChat is a true business app. An…
No other job is as rewarding and demanding as building an iPhone app is. It is not really in the hands of the developer for the success of an iPhone app. Many factors operate jointly for every iOS application's success in the market.
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…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

591 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