'bridging cultures & improving education through better dictionaries & terminology ...'
[Jan 2018] Version 2018 Now Available for TLex Suite, tlTerm, tlCorpus, tlDatabase (See What's New ») All existing users get automatic free upgrades to the latest version.
TLex is 16 years old this year - thank you to all our customers/users who have supported us so far.
[Mar 2018] Easter Update released with more new features! 🎥 VIDEO: WHAT'S NEW »
[Feb 2018] ❤ Valentine's Day Update released with many new features for tlTerm Terminology Software, TLex Lexicography Software, tlCorpus/tlDatabase etc. »
[Jul 2017] Volume discounts available for TLex, tlTerm, tlCorpus and tlDatabase »
🎥 Watch TLex/tlTerm development on our (very) informal live-streaming channel » (Also on: Twitch, LiveEdu)
Member of TermNET · EuralexEuralex 2018 Sponsor »

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]


• 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.

 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)


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

« Back to List of Knowledge Base Articles



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

Advanced Search Quick-help:
&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