• Problem using Domino Data Services with Full Text Index

    By App Dev 1 decade ago
    Hi!
    
     
    
    I want to use a notes database as data storage for a web application, using REST (Domino Data Services) for reading and writing documents.
    
     
    
    To read documents, I use &quot;View/folder entries GET&quot;. Because I have to filter the documents by more than one field, I can&#39;t use the &quot;keys&quot; parameter (see <a href="http://www.openntf.org/internal/home.nsf/response.xsp?action=openDocument&amp;documentId=396EF51A4E03204E86257A3D005463C3&amp;MainID=67719CE9FB23D40286257A39001EAAC5" target="_blank">REST&nbsp;API&nbsp;-&nbsp;Using&nbsp;dates&nbsp;and&nbsp;multiple-value&nbsp;keys&nbsp;for&nbsp;view&nbsp;queries</a>), so I decided to use the &quot;search&quot; parameter to execute a full text search.</div>
    
    &nbsp;
    
    My problem is, when I add a document via &quot;Document collection POST&quot;, the full text index is not updated for the next 15 to 20 minutes, even though the update frequency of the database is set to &quot;immediate&quot;.<br/>
    <br/>
    I need the document to be read immediately after creation. Do you have any ideas how I can resolve this problem?</div>
    
    &nbsp;
    
    Greetings,
    
    Martin
    
    • Need more info ...

      By Dave Delay 1 decade ago

      Martin,

       

      Because of the holidays and vacation schedules, we may not have an answer right away.  Meanwhile, some more information might be helpful.  For example, what happens when you create a document without the data service (e.g. using the Notes client or an XPages application)?  Does the full text index update immediately?

       

      Thanks.

       

      -- Dave

      • Problem using Domino Data Services with Full Text Index - server specifications

        By App Dev 1 decade ago
        Hi Dave,
        
        &nbsp;
        
        thanks for your fast reply.
        
        &nbsp;
        
        I deleted and created some documents using the Notes Client. The full text index was updated only after ~15 minutes.
        
        &nbsp;
        
        This behavior manifests for every database i created on this server, which is a Domino 9.0 Server HF328 64-bit on a Windows Server 2012 R2 64-bit. The relevant Variables in the notes.ini are:
        
        • ServerTasks=Update,Replica,Router,AMgr,AdminP,DECS,HTTP
        • ServerTasksAt1=Catalog,Design
        • ServerTasksAt2=UpdAll
        • ServerTasksAt5=Statlog
        • Update_Fulltext_Thread=1
        • UPDATE_ACCESS_FREQUENCY=7 (also tested other values, e.g. 30)
        • UPDATE_NOTE_MINIMUM=20 (also tested other values, e.g. 1)
        • UPDATERS=1
        There&#39;s only one program document: &quot;dbmt -compactThreads 2 -updallThreads 2 -ftiThreads 2 -compactNdays 3 -force 1 -range 02:00 AM 07:00 AM&quot; is run &quot;at server startup only&quot;.
        
        &nbsp;
        
        &nbsp;
        
        Greets,
        
        Martin
        
        • Reproduced the problem ...

          By Dave Delay 1 decade ago

          Martin,

           

          Good news is I reproduced the problem.  I also spent some time searching the Internet for the answer (I suppose you have done that too).  I found lots of pages warning that "immediate" update isn't the same thing as instantaneous.

           

          Bad news is I haven't found a work around.  Since this problem is not specific to the data service, please consider posting a question to the Notes & Domino forum here:

           

          http://www-10.lotus.com/ldd/ndseforum.nsf

           

          Or you can raise the question through other support channels.

           

          Sorry I don't have a better answer, but please let me know what you find.  If all else fails I suppose we could consider a future enhancement to the data service.  For example, we could add a URL parameter to trigger an immediate FT index update.

           

          Thanks. 

           

          -- Dave

          • Thanks

            By App Dev 1 decade ago
            Hi Dave,
            
            &nbsp;
            
            thanks again for your reply.
            
            &nbsp;
            
            I posted the question under <a href="http://www-10.lotus.com/ldd/ndseforum.nsf/xpTopicThread.xsp?documentId=48754DAD9596046C85257C58002F4781" target="_blank">http://www-10.lotus.com/ldd/ndseforum.nsf/...</a> and will post any solution here.</div>
            
            &nbsp;
            
            Greets,
            
            Martin