The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

I'm excited to use the new SQLAnywhere 11 full text search feature, but I haven't been able to find an answer to one question in the docs.

I can set a text index to refresh every 24 hours using 'AUTO REFRESH EVERY 24 HOURS'

So when in that 24 hour period does it refresh? Every 24 hours from when the statement is executed? 24 hours from the first refresh? midnight?

Or am I stuck with a manual index and events firing refreshes?

It would be nice if I could control when that processing is going to occur (say, after the incoming data has finished processing for the night).

asked 18 Jun '10, 08:11

Jen's gravatar image

Jen
80235
accept rate: 0%


An AUTO REFRESH text index will be refreshed for the first time within a minute or so after being created, and then every time the interval specified in the EVERY clause passes.

Note that an AUTO REFRESH text index may be automatically refreshed before the specified interval elapses if the database server determines there were a lot of data changes - if the amount of data to be added to the index exceeds 20% of the currently indexed data, or over 50% of the indexed data is deleted.

So there is no way to guarantee the time when the text index will be refreshed using AUTO REFRESH, unless you are sure that the volume of changes is not too high.

permanent link

answered 18 Jun '10, 14:53

Elmi%20Eflov's gravatar image

Elmi Eflov
7811014
accept rate: 31%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×137
×15

question asked: 18 Jun '10, 08:11

question was seen: 708 times

last updated: 18 Jun '10, 14:53