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

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

    Thanks
    Giri

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

    Michael

Posting Permissions

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