Depending what you want, there are much faster and simpler techniques
available using IBO

----- 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
>
>
>