home *** CD-ROM | disk | FTP | other *** search
- !---------------------------------------------------------------------
- !
- ! BASIC PROPERTIES
- !
- !---------------------------------------------------------------------
-
- !
- ! Path where index tables are held. Can be absolute or relative
- ! to the properties file. Defaults to tablePath.
- !
- indexPath=./index
- !
- ! Path where system tables are held. Can be absolute or relative to
- ! the properties file. Defaults to tablePath.
- !
- systemPath=./system
- !
- ! Path where database tables are held. Can be absolute or relative
- ! to the properties file. Defaults to "current" directory.
- !
- tablePath=./tables
- !
- ! Path where results set tables are held. Can be absolute or relative
- ! to the properties file. Defaults to tablePath.
- !
- tmpPath=./tmp
- !
- ! Non-zero means paths are relative to the properties file.
- ! Default is absolute paths for files.
- !
- relativeToProperties=1
- !
- ! Alternative partitions can be defined so that tables can be placed
- ! in multiple locations. Each partition is numbered: 1, 2, 3,... Tables
- ! can be created on partitions using the syntax
- !
- ! CREATE TABLE <name> ON PARTITION <number>...
- !
- ! The partition count has to be supplied.
- !
- !partitionCount=2
- !
- ! The locations of each partition must be supplied. These are always
- ! absolute path names.
- !
- !partition1=d:/petes
- !partition2=c:/temp
-
-
- !---------------------------------------------------------------------
- !
- ! TUNING PROPERTIES
- !
- !---------------------------------------------------------------------
-
- !
- ! The amount of each column to cache, expressed either as an absolute
- ! number of rows or as a percentage figure. Defaults to 256 or 10 respectively.
- !
- cacheAmount=512
- !
- ! CACHE_ROWS Must be one of CACHE_ROWS or CACHE_PERCENT. Determines whether
- ! to cache columns in tables based on an absolute number of rows, or the
- ! percentage number of rows in the table.
- !
- cacheCondition=CACHE_ROWS
- !
- ! The percentage cache hit improvement required in order to move the
- ! cache to a new location in a column.
- !
- ! (Currently not implemented).
- !
- cacheResetPercent=10
- !
- ! Non-zero means that database changes do not get written to the
- ! database immediately. See tuning.html.
- !
- fastUpdate=0
- !
- ! Percentage of free space in an index that must be present before
- ! the index reorganises itself. High values means frequent index
- ! reorganisation. Low values means slow index inserts.
- !
- indexLoad=5
- !
- ! The number of cache misses to include in calculations of the next
- ! base for the cache.
- !
- ! (Currently not implemented).
- !
- missesInCacheStats=100
- !
- ! Non-zero means that results sets get instantiated on disk. By default
- ! InstantDB holds results sets emtirely in memory (apart from Binary
- ! columns). For large resulst sets this can be a problem. This property
- ! forces all results sets to be held on disk.
- !
- resultsOnDisk=0
- !
- ! Similar to cacheCondition but applies only to disk based
- ! results sets. Default is CACHE_ROWS.
- !
- resultsSetCache=CACHE_ROWS
- !
- ! Similar to cacheAmount but applies only to disk based
- ! results sets. Default is 100.
- !
- resultsSetCacheAmount=100
- !
- ! Number of rows to read into the disk look ahead buffer.
- ! Recommended to be set somewhere around 128 to 256.
- ! Default is 20.
- !
- rowCacheSize=128
- !
- ! By default, InstantDB only does a cursory search for deleted rows during
- ! UPDATE statements. Setting searchDeletes=1 causes more detailed searches
- ! for deleted rows. This slows down UPDATE executions, but reults in more
- ! compact tables. Default is 0.
- !
- searchDeletes=0
- !
- ! The interval, in milliseconds, between checks for statement execution
- ! timeouts. Default is 5000.
- !
- !timerCheck=5000
-
- !---------------------------------------------------------------------
- !
- ! LOGGING AND DEBUGGING PROPERTIES
- !
- !---------------------------------------------------------------------
-
- !
- ! Non-zero means include SQL statements in the export file.
- !
- exportSQL=0
- !
- ! Non-zero means trace output also directed to console.
- ! Defaults to 0.
- !
- traceConsole=0
- !
- ! Relative or absolute path where exporting and tracing goes.
- !
- traceFile=./idb_trace.log
- !
- ! Bitmap of various items that can be traced. See debug.html.
- ! Defaults to 0.
- !
- traceLevel=2
-
- !---------------------------------------------------------------------
- !
- ! TRANSACTION AND RECOVERY PROPERTIES
- !
- !---------------------------------------------------------------------
-
- !
- ! 0 means do not perform recovery on startup.
- ! 1 means perform automatic recovery
- ! 2 (default) means prompt the user using standard in
- !
- recoveryPolicy=1
- !
- ! Sets the level of transaction journalling. See trans.html.
- ! Defaults to 1.
- !
- ! 0 - No journalling takes place.
- ! 1 - Normal journalling (default).
- ! 2 - Full journalling.
- !
- transLevel=1
- !
- ! When doing an import, defines the number of rows imported
- ! before the transaction is committed. Recommended value 8192.
- ! defaults to 100.
- !
- transImports=100
-
- !---------------------------------------------------------------------
- !
- ! DATE, TIME AND CURRENCY PROPERTIES
- !
- !---------------------------------------------------------------------
-
- !
- ! Number of digits after decimal point in currency outputs. Defaults to 2.
- !
- currencyDecimal=2
- !
- ! Currency symbol used in currency outputs. Defaults to $.
- !
- currencySymbol=$
- !
- ! Default format for date columns. Defaults to "yyyy-mm-dd".
- !
- dateFormat="yyyy-mm-dd"
- !
- ! If set, then all two digit dates less than its value are interpreted
- ! as 21st century dates.
- !
- !milleniumBoundary=50
- !
- ! Set to 1 causes the date string "now" to store a full timestamp.
- ! Default is to store only the date for fields with now hour in the
- ! format string.
- !
- nowMeansTime=0
-
- !---------------------------------------------------------------------
- !
- ! STRING HANDLING PROPERTIES
- !
- !---------------------------------------------------------------------
-
- !
- ! If set to 1 then String hashes use the JDK Object.hashCode() function.
- ! By default, uses InstantDB's String hashing.
- !
- altStringHashing=0
- !
- ! Set to 1 to cause LIKE clauses to always perform case insensitive
- ! comparisons.
- !
- likeIgnoreCase=0
- !
- ! Same as SET LITERAL STRICT_ON. Prevents string literals being interpreted
- ! as column names or numbers. Default is 0.
- !
- strictLiterals=0
- !
- ! Set this value to 1 (one) if you would like PreparedStatement.setString()
- ! to ignore "\" (backslash) characters when proceesing string constants.
- ! When set, InstantDB will not attempt to interpret \ as the start of an
- ! escape sequence. Default is 0.
- !
- prepareIgnoresEscapes=1
-
- !---------------------------------------------------------------------
- !
- ! MISCELLANEOUS PROPERTIES
- !
- !---------------------------------------------------------------------
-
- !
- ! Allows selected InstantDB keywords to be un-reserved.
- ! e.g. ignoreKeywords=url,quote would allow the keywords
- ! url and quote to be used as table or column names.
- !
- ! This faciliy is provided for compatatbility reasons only.
- ! It's use is not recommended AND IS NOT SUPPORTED.
- !
- !ignoreKeywords
- !
- ! Non-zero means database is opened in read only mode.
- !
- readOnly=0
-