delay before indexing (OpenInsight 64-bit) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

{{tag>category:"OpenInsight 64-bit" author:"Barry Stevens" author:"bob carten"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== delay before indexing (OpenInsight 64-bit) ====
=== At 18 JUL 2023 10:24:30PM Barry Stevens wrote: ===
 
 
<QUOTE>
In the environment settings, the option 'delay before indexing'.



No indexing server running



When set to 0 , and you have 'update before query' selected, will this do an immediate update of the indexes? or do you have to set it to say 5 and wont update untill 5 seconds have past????



My understanding in all these years was setting it to 0 did an immediate update on a SELECT, but I have just been queried.
</QUOTE>
----

=== At 19 JUL 2023 10:56AM bob carten wrote:  ===

<QUOTE>

If you have update before query selected and your query uses an indexed column then openinsight will update the indexes for that column.   It calls index. Flush( tablename, columnname ) .







</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=0C93EB590845FE4BA48D289A63723E10|View this thread on the Works forum...]]