Unanswered: DBArtisan Vs Unix command prompt query
Just a small query ..
Can someone put some light on performance of Execution of a query from DBArtisan and through isql on unix prompt in terms of execution time of the script? thought i used getdate().. I would like to know if someone has other issues ..
The actual execution time of the query should be the same. What makes a difference sometimes is the handling of large result sets. isql or similar simply print everything to stdout, which is (normally) quite fast. DBArtisan and other GUI tools will create a GUI table to hold the results. This uses a lot more memory, and takes a lot more processing power to handle.