When a user cancels the opening of an analysis file and the analysis file is connected to an information link and reading the data; *the Spotfire Server should send a cancel to the database to cancel the query*. Currently, even though the user has canceled the requested (from client), the Spotfire Server seems to run all the queries submitted to the database to completion. It does not really cancel. It should be like when you are using a DB visualizer or database tool; after submitting the query, there may be an option to cancel query.
Not all data sources support this feature and not all drivers implement it but it will great to implement it on the major ones. Microsoft SQL Server and Oracle both support user query cancels and they have implemented this feature on their respective JDBC drivers.