Performance Gains
Teamleader Focus traditionally required one API call per row to retrieve the custom field values using a table function. For ease of use, views such as ContactsAll are available in the V1Flat and V2Flat schema that retrieve both base data as well as custom field values.
However, the throughput is extremely slow, peaking at 200 rows per minute.
Teamleader has considerably improved the performance of custom field value retrieval for the following V2 tables by adding the custom field values to the base table:
CompaniesContactsDeals
The maximum throughput when retrieving custom field values is increased by upto approximately a factor 100 (yes: that is up to one hundred times faster).
Fair Usage
Besides offering considerably better performance, the extended tables also require significantly less handling on Invantive Cloud. This allows you to execute up to 100 times larger queries on Invantive Cloud or Power BI without exceeding the Fair Usage limits of your subscription.
Migration
To enjoy the up to 100x better performance it is recommended to replace all use of the following tables by the listed base table:
| Schema | Original Table Name | New Table Name |
|---|---|---|
V2Flat |
CompaniesAll |
V2.Companies |
V2Flat |
ContactsAll |
V2.Contacts |
V2Flat |
DealsAll |
V2.Deals |
V1Flat |
CompaniesAll |
V2.Companies |
V1Flat |
ContactsAll |
V2.Contacts |
V1Flat |
DealsAll |
V2.Deals |
In general, column names and contents will be identical or very similar.
When another approach is used to retrieve the custom field values, an optimization is possible too, but may require a larger effort.
Limitations
Multi-select
The Invantive SQL-driver for Teamleader Focus currently does not generate (fast) tables for multi-select custom fields. These may be added in a future release.
Tasks and other tables
Teamleader does not yet offer the custom field value improvements for other tables. The SQL-driver will nonetheless add them already, so that when they become available, the fields will be filled automatically.
End of Life
Starting January 2025, the original tables which retrieve custom field values for companies, contacts and deals may be removed from new Invantive-releases without prior notice. It is strongly recommended to replace the tables before 2025 by the faster variants.
Availability
The improved performance tables are available starting release 24.0.293. This release is expected to be taken into production on Invantive Cloud on August 27, 2024.