www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Virtuoso Functions Guide

Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
vt_batch_update
vt_drop_ftt
composite
composite_ref
contains
vt_batch
vt_batch_d_id
vt_batch_feed
vt_batch_feed_offban...
vt_create_text_index
vt_is_noise
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Phrases
RDF data
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web & Internet
XML
XPATH & XQUERY

Functions Index

VT_BATCH_UPDATE

Set batch mode update of free text indexing.
integer DB.DBA.VT_BATCH_UPDATE (in table varchar, in flag varchar, in interval_minutes integer);
Description

This function controls the time of update of a text index. If flag is ON, changes are accumulated into a change tracking table and applied as a batch. If flag is OFF, the text index is updated in the same transaction as the indexed data itself. The change tracking table is automatically created and is named VTLOG_<q>_<o>_<table>, in the qualifier and owner of the indexed table, where q, o and table are the qualifier, owner and name of the table. The changes accumulated into that table can be explicitly applied to the index using the VT_INC_INDEX_<q>_<o>_<table> function.

Parameters
table – the name of the table to perform batch updating of.
flag – If ON, updates are in batch mode, if OFF, they are synchronous.
interval_minutes – the update interval. NULL means that updates are not scheduled.
Return Types

Errors
SQLState Error Code Error Text Description

Examples