I have a few questions with regards to saving and managing history of query results within TDA. When you right-click on a result set, you can select Compare To -> Save Current/Manage History. The questions follow:
-
Is there a limit on the number of items you can have in history?
1.a. If so, where is this configurable?
-
Are we saving the results sets when we “Save Current”?
2.a. If so, where are these stored?
2.b. Is it safe to assume that the Historical query is not re-executed when comparing results?
Hope all is well.
Ben
We have evaluated this feature and it will be removed for version 2.1 and you will not be able to get to the history you have saved in the 2.0 version of TDA. The way we will handle this in 2.1 is to just do it with “Toad Editor Files” (TEF files). You can do this in 2.0 too it is just a little bit clunkier (Do a save file in the editor and choose the TEF file format). The TEF file format is a binary format that contains an editor and all the data in its showing result sets. Now to answer your questions.
-
No limit.
-
Yes.
a. In the application data directory. However you will lose the ability to restore these when you upgrade to 2.1. Saving as TEF files will allow you to work with this in both 2.0 and 2.1 (The interface will be improved in 2.1 to make this easier to work with).
b. Yes (We don’t re-execute the query).
/Mauritz