AfrikaansDeutschEspañolFrançaisKiswahiliSerbo-Croatian简体中文
[Jul 2017] New volume discounts available for TLex, tlTerm, tlCorpus and tlDatabase »
[Oct 2016] Watch TLex/tlTerm development on our (very) informal live-streaming channel » (Also: YouTube, Twitch)

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