Subject | Re: [IBO] Full Text Search implementation |
---|---|
Author | robert.gilland |
Post date | 2010-09-05T22:49:12Z |
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.
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.