NIH | National Cancer Institute | NCI Wiki  

Error rendering macro 'rw-search'

null

Versions Compared

Old Version 40

changes.mady.by.user Unknown User (yadavs)

Saved on

compared with

New Version 41

changes.mady.by.user Unknown User (bleekert)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Loading any terminologies can be very time consuming and resource intensive and this can be helped by the following recommendations for database optimization.  This is more necessary the larger the terminology gets. The LexEVS configuration file, <LEXEVS_HOME>/resources/config/lbconfig.props, should be changed depending on how the primary key for the database should be generated. The default setting for the value of the database primary key is the following:

Note

The default for the DB_PRIMARY_KEY_STRATEGY property changed in LexEVS 6.0.3 to SEQUENTIAL_INTEGER. If you are at 6.0.3 or later your performance will not be impacted by leaving the default setting. You will need to change the property only if you want the advantage of globally unique IDs.

Code Block
# DB_PRIMARY_KEY_STRATEGY indicates which strategy will be used
# for the primary key of the database tables.
# WARNING - This cannot be changed after the initial
# schema installation.
#
# Allowable values include:
#
#	"GUID"
#		- Primary Keys are implemented as random GUIDs.
#	"SEQUENTIAL_INTEGER"
#		- Primary Keys will be sequentially incremented
#		- as Ingeter values.
DB_PRIMARY_KEY_STRATEGY=GUID

...