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
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.
Quick-Help
The quick-help below shows you how to construct advanced search queries on the Knowledge Base.
| Advanced Search Quick-help: | ||
| Symbol | Functionality | Example |
| & | AND | windows & odbc |
| | | OR | windows | odbc |
| "..." | Exact phrase | "cover flow" |
| _ | Single-character wildcard | linu_ |
| % | Multi-character wildcard | activat% |
| /(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