'bridging cultures & improving education through better dictionaries & terminology'
Version 2020 released for TLex, tlTerm, tlCorpus, tlDatabase (32/64-bit Windows & macOS. What's New) All users may upgrade.
Watch tlTerm easily load millions of terms »
macOS Catalina versions available »

Knowledge Base : TshwaneDJe Software

The TshwaneDJe Knowledge Base contains a small collection of technical articles with information on specific issues to assist you with the configuration or use of our software. You can search through the Knowledge Base using the search box below, or by browsing the list of articles. We will continually be adding new articles over time. If you don't find a solution here, please also try the FAQ or other support resources.

Search for:

ODBC: Performance Tuning a Large TLex / tlTerm / tlDatabase Database [Advanced]


PostgreSQL

If performance on a very large database is slow (particularly with loading entries), check (using e.g. pgAdmin) if the index of the entry_id column of the "(prefix)_tree" table has 'substring' call in it - if so, delete and recreate the index of this column as follows, e.g.

DROP INDEX idx_YOURPREFIX_tree_2;
CREATE INDEX idx_YOURPREFIX_tree_2
 ON YOURPREFIX_tree
 USING btree
 (entry_id COLLATE pg_catalog."default");

This can significantly improve entry loading time in certain cases.
If performance on a very large database is slow (particularly with loading entries), you could also try changing the postgresql.conf parameter cpu_tuple_cost to a higher value (e.g. 0.1, or 1 - default value is 0.01)


General

Running the following (once-off) may help: Tools / Database administration / Optimise indexes

« Back to List of Knowledge Base Articles

 

Quick-Help

The quick-help below shows you how to construct advanced search queries on the Knowledge Base.

Advanced Search Quick-help:
SymbolFunctionalityExample
&ANDwindows & odbc
|ORwindows | odbc
"..."Exact phrase"cover flow"
_Single-character wildcardlinu_
%Multi-character wildcardactivat%
/(1-9)Within x words of one another, given order"windows odbc"/8
@(1-9)Within x words of one another, any order"windows odbc"@8
#XOR (find one or the other, but not both)mac # windows
^None of ...^mac


The Knowledge Base was created with TLex, and is published online and updated using the TLex Online Publishing System