Limitations for "In-database and in-memory data loading" in TIBCO Cloud™ Spotfire® web client
Article ID: KB0078503
Updated On:
| Products | Versions |
|---|---|
| TIBCO Cloud Spotfire | Current version |
Description
In the TIBCO Cloud™ Spotfire® web client, to ensure stable performance, certain limits exist on data loading from external systems. Depending on the load method used, keep these limitations in mind when working with data connections in the web client.
Issue/Introduction
This article describes the limitations for "In-database and in-memory data loading" in TIBCO Cloud™ Spotfire® web client
Environment
All supported operating systems
Resolution
In-memory loading limitations:
Data import row limit: The maximum number of rows in a data table that can be imported from an external data source in TIBCO Cloud Spotfire web client is 2000000. If an imported data table contains more rows, only the first 2000000 rows will be included.
If you want to work with data that contains more rows, this is supported by configuring the connection to allow in-database loading of the data tables. This configuration can be done in an installed client, by the connection author.
In-database loading limitations:
External data row limit: The maximum number of rows that can be retrieved and visualized is 500000, when working with in-database data. This does not limit the number of rows allowed in the underlying data table in the external data source, but only the amount of data that can be fetched in a query to the data source. The limit affects, for example, visualizations, the expanded data panel, and certain filter types.
You might exceed this limit if you configure a complex visualization where too many items are shown on the axes, or if you create a filter for a column that contains too many unique values. You can often work around the limit by, for example, filtering the data or configuring the visualization to show fewer items.
If a visualization or filter is configured to show more than 500000 items, these elements will not be rendered in the analysis, and an error message will be displayed.
Table visualization row limit: The table visualization can display a maximum of 10000 rows of data, when working with in-database data. If the data table contains more rows, only the first 10000 will be visualized.
Data import row limit: The maximum number of rows in a data table that can be imported from an external data source in TIBCO Cloud Spotfire web client is 2000000. If an imported data table contains more rows, only the first 2000000 rows will be included.
If you want to work with data that contains more rows, this is supported by configuring the connection to allow in-database loading of the data tables. This configuration can be done in an installed client, by the connection author.
In-database loading limitations:
External data row limit: The maximum number of rows that can be retrieved and visualized is 500000, when working with in-database data. This does not limit the number of rows allowed in the underlying data table in the external data source, but only the amount of data that can be fetched in a query to the data source. The limit affects, for example, visualizations, the expanded data panel, and certain filter types.
You might exceed this limit if you configure a complex visualization where too many items are shown on the axes, or if you create a filter for a column that contains too many unique values. You can often work around the limit by, for example, filtering the data or configuring the visualization to show fewer items.
If a visualization or filter is configured to show more than 500000 items, these elements will not be rendered in the analysis, and an error message will be displayed.
Table visualization row limit: The table visualization can display a maximum of 10000 rows of data, when working with in-database data. If the data table contains more rows, only the first 10000 will be visualized.
Additional Information
Feedback
Yes
No
Powered by
