Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007

    Unanswered: DBArtisan Vs Unix command prompt query

    Hello DBAs,

    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 ..


  2. #2
    Join Date
    Jan 2003
    Geneva, Switzerland
    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts