Robert,

Sorry I have not responded before now. I've still been fairly ill and not
keeping up with everything as I would like.

Were you able to figure out anything on this?

I wanted to mention that you should look and see how many records are in
your queue table. If you are doing very broad changes to your data it might
be more efficient overall to unload the index, make the sweeping changes,
and then reload the index.

Will you tell us more about what it is you are doing?

Thanks,
Jason Wharton

----- Original Message -----
From: "robert.gilland" <robert.gilland@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, September 06, 2010 4:33 PM
Subject: Re: [IBO] Full Text Search implementation


>I have now been running the "resyncqueue" method and it has taken so far
>over 12 hours of CPU time. Obviously I cannot use this method.
> Quite disappointed really. I won't cancel it however, I want to see if it
> ever finishes and what are the outcomes of the method.
>
> --- In IBObjects@yahoogroups.com, "robert.gilland" <robert.gilland@...>
> wrote:
>>
>> Hi Jason,
>>
>> I think you may have misunderstood my question.
>> My issue is that the Queue is never cleared and put into the
>> main full test search word tables.
>> It is not a transaction level issue as far as I can see.
>>
>> ie. i have in my "Q" table 90000 records. When do they actually get
>> out of the "Q" and into the actual word search tables?
>>
>> I do not in any way know when a product description is added to my
>> product description table. So I thought the triggers would be the
>> ones to ensure everything was up to date.
>>
>> Do I simply call the "resyncqueue" method as often as I can?
>>
>> Kind Regards,
>>
>> Robert.
>>
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>