June 4, 2008 at 3:03 am
Folks,
My client is looking for full-text search for his read-only db. The site provides public search facilities for some historical data. This data is to be updated monthly via SSIS.
He is looking to use shared-hosting but his chosen provider does not allow full-text search catalogs for SQL 2005.
The database is small, just 20mb, and is not likely to more than double over the next 6 years as it is archaeological data for a limited number of sites. I am contemplating using persisted views as an alternative to full-text searches. Can anyone advise me here on whether in this case persisted views would possibly suffice in this case?
Any advice regarding the use of indexed views would be appreciated.
K
June 4, 2008 at 9:17 am
Using persisted views could, theoretically, get you most of what you need. But it won't get you all of the features of full-text indexing, at least not easily.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 4, 2008 at 3:31 pm
Thanks G,
I found out that I cannot create an index on a view that has TEXT fields. No good to me then.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply