hubbledotnet 定时更新索引

文章：http://www.cnblogs.com/eaglet/archive/2010/08/25/1808143.html

这里用的是update模式创建表

1、首先在数据库中创建触发器表 

CREATE TABLE [HBTrigger_job_SearchKey] (

[Serial] [bigint]  IDENTITY (1, 1)  NOT NULL,

[Id] [int]  NOT NULL,

[Opr] [char]  (16) NULL,

[Fields] [nvarchar]  (4000) NULL)

 

ALTER TABLE [HBTrigger_job_SearchKey] WITH NOCHECK ADD  CONSTRAINT [PK_HBTrigger_job_SearchKey] PRIMARY KEY  NONCLUSTERED ( [Serial] )

SET IDENTITY_INSERT [HBTrigger_job_SearchKey] ON

2、在job_SearchKey 创建修改 删除 触发器

修改触发器：

create Trigger [dbo].[HBTrigger_job_SearchKey_Update]
    On [dbo].[job_SearchKey]                        
    for Update                         

    As                                       
    DECLARE @updateFields nvarchar(4000)
    set @updateFields = ''

    if Update(keyid)          
    begin
    set @updateFields = @updateFields + 'keyid,'
    end       

    if Update(keyword)          
    begin
    set @updateFields = @updateFields + 'keyword,'
    end       

    if Update([Count])          
    begin
    set @updateFields = @updateFields + 'Count,'
    end       

    if Update(type)          
    begin
    set @updateFields = @updateFields + 'type,'
    end       

    if Update(addTime)          
    begin
    set @updateFields = @updateFields + 'addTime,'
    end   
     if Update(upTime)          
    begin
    set @updateFields = @updateFields + 'upTime,'
    end   
     if Update(RecordCount)          
    begin
    set @updateFields = @updateFields + 'RecordCount,'
    end   

    if @updateFields <> ''
    begin
    insert into HBTrigger_job_SearchKey select keyid, 'Update',  @updateFields from Inserted
end

删除触发器

create Trigger [dbo].[HBTrigger_job_SearchKey_Delete]
 
On [dbo].[job_SearchKey]
 
for Delete
 
As
 
insert into HBTrigger_job_SearchKey select keyid, 'Delete', '' from Deleted

注：插入操作不用添加触发器hubbledotnet会自动处理

3、打开hubbledotnet（Query Analyzer） 在job_SearchKey右键选择Table InfoàAttributes

         TableSynchronization设置为true,TriggerTableName 添写第一步创建的触发器表名

4、打开hubbledotnet（Query Analyzer）点击Managerment菜单 选择

Task scheduler managerment 点击Add

exec SP_SynchronizeTable 'job_SearchKey', 5000, 2 是hubbledotnet固定

文章地址：http://www.cnblogs.com/eaglet/archive/2011/03/02/1969219.html