Hello, what exactly is the difference (and advantages/disadvantages) between a fulltext index and a regular index on a varchar column? When would I use which index? I have a multitude of varchar columns (addresses - city name, street name etc.) which I need to be searchable in the most performant way and I'm trying to figure out which i...
I'm indexing a model with xapian/haystack. When i test it on my local machine everything works just fine, but when i try to save a model on the server Xapian throws a DatabaseLockError Exception Type: DatabaseLockError Exception Location: /opt/python2.6/lib/python2.6/site-packages/xapian.py in __init__, line 2886 2886: _xapian.Writable...
I have this sql query where I'm trying to use CONTAINS to search the title field. But I get this error. "Cannot use a CONTAINS or FREETEXT predicate on column 'Title' because it is not full-text indexed." The Titles table has been indexed and a CONTAINS works fine with a simple search. Does anyone know what I'm doing wrong? Are CONTA...
We are writing unit tests for our ASP.NET application that run against a test SQL Server database. That is, the ClassInitialize method creates a new database with test data, and the ClassCleanup deletes the database. We do this by running .bat scripts from code. The classes under test are given a connection string that connects to the ...
It appears to me as the easiest, most straightforward solution, but please correct me if I'm wrong. Instead of having a fulltext index on all individual columns of a table, isn't it better to just generate one single wide computed column and run the fulltext index against that only? It appears to me that it gets rid of all the issues o...
1) I have the text fields FirstName, LastName, and City. They are fulltext indexed. 2) I also have the FK int fields AuthorId and EditorId, not fulltext indexed. A search on FirstName = 'abc' AND AuthorId = 1 will first search the entire fulltext index for 'abc', and then narrow the resultset for AuthorId = 1. This is bad because it ...
I'm trying to get an idea of fulltext index growth and gauge its long-term memory needs. Does it keep a cache of each search? (Knowing that the first search for a new keywords always takes slightly longer, and is subsequently faster) Will it grow indefinitely? Or is its size pretty much finite after its creation? Should I expect perfo...
I have SQL Server 2008 (Version 10.0.2531). The following annoying bug? happens, and maybe someone has a workaround: When I create a computed column which also combines values from a scalar valued function, and then add it to the fulltext index via the wizard, everything works fine. The fulltext index correctly picks up on the column a...
Hi I am rebuilding a full text catalog as follows: ALTER FULLTEXT CATALOG myCatalog REBUILD It is not populating my indexes. When i use the FULLTEXTCATALOGPROPERTY to check the properties I am getting the populating status always as 0 and the itemcount as 0. If i populate the index(which is a part of the catalog above) directly as fo...
I have created a fulltext catalog that stores the data from some of the columns in a table, but the contents seem to have been split apart by characters that I don't really want to be considered word delimiters. ("/", "-", "_" etc..) I know that I can set the language for word breaker, and http://msdn.microsoft.com/en-us/library/ms34518...