Solved

SQL Server full-text search website integration

Posted on 2010-09-15
2
320 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
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 is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

756 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