Solved

SQL Server full-text search website integration

Posted on 2010-09-15
2
315 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
Comment Utility
>>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
Comment Utility
>>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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
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 create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

763 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now