Sql-server – Index that mimics full-text-index

full-text-searchsql-server-compactupdate

I have a database that is retrieving information quite slowly, I asked a question and was told to use full-text-indexing, this worked, but now we switched over to a .sdf file and Sql Server Compact Edition 4.0 does not support full-text-indexing

Is there any index that will mimic the way a full-text-index works?

Update and Insert Statement taking forever

This is the code I am using:

 SELECT TimesUsed, Word FROM Predictions WHERE (Word LIKE @partialWord) ORDER BY TimesUsed DESC


PredTable = PredTA.GetDataByPartialWord(combo)
        If PredTable.Count = 1 Then PredTA.Update(PredTable(0).TimesUsed + 1, combo)
        If PredTable.Count = 0 Then PredTA.Insert(combo, 1)

Best Answer

Because Compact Edition is deprecated and doesn't support full-text search (or anything like it), I think the best solution here is to stop using Compact Edition and instead use SQL Server Express with Advanced Services, which includes full-text search capabilities.

Stop moving database files around between developers. This is just dangerous, regardless of whether you are using Compact Edition or proper editions of SQL Server. You should install a single instance of SQL Server, and everybody manage a single copy of the database. Use source control so that rolling back is easier than "use the copy of the file from Jimmy's machine and then add this change and take this table away..."

In order to convert back from Compact Edition to proper SQL Server, see this question and this question.

Related Question