Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

performance

TDV setting to write logs as asynchronous

My team would like to set TDV logs to asynchronous to get better on manage,inspect TDV logs and performance.
over 2 years ago in Spotfire Data Virtualization / performance Will not implement

Do cache refresh in push down where possible

In case the cache table is in the same database as all the other tables contributing to the cache, the cache refresh should run in full push down. This instead of selecting and bringing all the data from the database to the TDV server and then sen...
about 3 years ago in Spotfire Data Virtualization / performance Already exists

SingleStore and TDV: Make queries on tables that are on different databases but on the same SingleStore cluster run in push down

SingleStore does not have the concept of schemas, rather different databases are created instead of a single database with different schemas. This has an impact on the push down of queries that span different databases. This also limits the pushdo...
about 3 years ago in Spotfire Data Virtualization / performance Unlikely to implement

Parallel start execution of two or more scripts/jobs

dear sir/madam, I have multiple scrips that are independent of each other, for example scripts to do some calculations and then insert/update/delete data into tables in target database. For example script01, script02 and script03. Each script c...
about 3 years ago in Spotfire Data Virtualization / performance Future Consideration

add hint in SQL SELECT to explicitly choose which table to data-ship to which data source

At the moment there is a hint to suppress data-ship within a query. I do miss a hint to explicitly tell the TDV engine which table (or view) he must ship to another database (and which database). Reason: in some situations TDV does make decisions ...
over 4 years ago in Spotfire Data Virtualization / performance To be Reviewed

Uni-Directional Sync - Cluster Stability

In a typical cluster setup, Tibco recommends assigning one node as a timekeeper. This ensures optimal performance. However due to Memory and Processor peaks, the cluster nodes disconnect more often and cluster being out of sync. Can a uni-directio...
over 4 years ago in Spotfire Data Virtualization / performance To be Reviewed
135 VOTE

Add Massive Parallel Processing (MPP) capability on Windows Platform

Requesting Massive Parallel Processing (MPP) capability as a supported feature on Windows Platform. At the time of this request, this is only supported on Linux but it would be great to have the same feature supported on Windows Servers as well
almost 7 years ago in Spotfire Data Virtualization / performance Will not implement

Seperate JVM for cached objects

Currently, DV runs with single JVM for all server threads, user requests, caching,etc. and causing too high HEAP requirement, custom GC settings and unrecoverable exceptions. This is causing frequent restarts (due to node shunned alerts) and somet...
almost 7 years ago in Spotfire Data Virtualization / performance Needs Info

Use or support Zing JVM for better GC and server performance

We currently use large heap sizes >16gb and running into frequent client timeout issues caused by "Long GC pauses". We tried jvm fine-tuning with CMS and G1 GC. Other JVMs such as Azul's Zing/Zulu JVM would help in this case with true parallel ...
about 7 years ago in Spotfire Data Virtualization / performance Will not implement

Filter before Procedure Join

We are increasing the use of Web Services, thus more procedures. It is very common for us to join a web service to a relational table, however the procedure join is executed for every row. Is it possible to update the query engine to apply a filte...
over 7 years ago in Spotfire Data Virtualization / performance Will not implement