Subject Re: [IBO] Full Text Search implementation
Author robert.gilland
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.
>