How can I know when SQL Full Text Index Population is finished?

Posted by GarethOwen on Stack Overflow See other posts from Stack Overflow or by GarethOwen
Published on 2010-04-28T08:40:18Z Indexed on 2010/04/28 8:43 UTC
Read the original article Hit count: 165

Filed under:

fulltext-index

|

population

|

unit-testing

|

sql-server

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 unit test database rather than a production database.

Our problem is, that the database contains a full text index, which needs to be fully populated with the test data in order for our tests to run as expected.

As far as I can tell, the fulltext index is always populated in the background. I would like to be able to either:

Create the full text index, fully populated, with a synchronous (transact-SQL?) statement, or
Find out when the fulltext population is finished, is there a callback option, or can I ask repeatedly?

My current solution is to force a delay at the end the class initialize method - 5 seconds seems to work - because I can't find anything in the documentation.

© Stack Overflow or respective owner

Related posts about fulltext-index

Speed up SQL Server Fulltext Index through Text Duplication of Non-Indexed Columns

as seen on Stack Overflow - Search for 'Stack Overflow'
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… >>> More
Best way to handle SQL Server fulltext index updates

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I have a fulltext index which doesn't need to be immediately up-to-date, I'd like to spare myself the I/O (when I do bulk updates, I see a ton of I/O related to the index) and do the index updates during low usage times (nightly, perhaps even weekly). It seems there are two ways to go about… >>> More
MySQL - Fulltext Index Search Issue

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, Two rows in the my database have the following data: brand | product | style ================================================= Doc Martens | Doc Martens 1460 Boots | NULL NewBalance | New Balance WR1062 SG Width | NULL Mininum word length is set to 3, and… >>> More
Create fulltext index on a VIEW

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to create a full text index on a VIEW? If so, given two columns column1 and column2 on a VIEW, what is the SQL to get this done? The reason I'd like to do this is I have two very large tables, where I need to do a FULLTEXT search of a single column on each table and combine the results… >>> More
I'm trying to build a query to search against a fulltext index in mysql

as seen on Stack Overflow - Search for 'Stack Overflow'
The table's schema is pretty simple. I have a child table that stores a customer's information like address and phone number. The columns are user_id, fieldname, fieldvalue and fieldname. So each row will hold one item like phone number, address or email. This is to allow an unlimited number of each… >>> More

Related posts about population

Exception.Data population bug?

as seen on Stack Overflow - Search for 'Stack Overflow'
Okay, .NET geniuses, here's the relevant part of my code: adapter.Fill(table); return; } catch(Exception ex) { SqlException sqlEx = ex as SqlException; I have an exception that's being thrown by adapter.Fill(), and when I put a breakpoint on the first line in the exception handler… >>> More
Programmatically Create a Full Text Population Schedule via TSQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I have a SQL 2005 TSQL script which sets up my FT Catalog and Indexes, but I would like to also create a Population schedule for these indexes via the same Code, can anyone point me in the right direction. Thank you Matt >>> More
Nested form using accepts_nested_attributes_for with pre-population from another table

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Rails 2.3.5 and have a nested structure as follows: Lists has_many Items Items_Features has_many Features Items_Features has_many Items Items_Features has a text field to hold the value of the feature Then I have a nested form with partials to update and display this so that it updates… >>> More
Combobox population problem

as seen on Stack Overflow - Search for 'Stack Overflow'
So I have a combobox - the designer code: this.cmbStatusBox.Items.AddRange(new object[] { "Ordered", "Cooking", "In-transit", "Delivered"}); The formload code: if (mainForm.boolEdit == true) { this.cmbStatusBox.Items.AddRange(new object[] { "Cooking", … >>> More
Query in data population using select in jsp

as seen on Stack Overflow - Search for 'Stack Overflow'
I am populating data using <select name="test"> <option value='<%=session.getAttribute("tList")%>'><%=session.getAttribute("tList") %></option> </select> but the values are getting display in a single row in the combo box not row wise,where i am going wrong ? >>> More