Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2011

    Unanswered: performance time


    the query execution time in sqladv and isql is different. isql is faster.
    i have a vb & sybase application. so as far as the application concerned
    which execution time is applicable .one procedure is called in side the form.
    can any one tell that why isql is faster. for query optimization which execution time should be considered.

    pls advice on this

    thanks & regards

  2. #2
    Join Date
    May 2005
    South Africa
    Provided Answers: 1
    If you run isql on the db server then it eliminates network traffic and will be faster.
    Instead of transferring all the data to the client try select * into #t1 from thetable
    The difference in time will be the time it takes to transfer the data across the network.
    Try increasing the Network Packet Size to improve performance on the client.

  3. #3
    Join Date
    Feb 2011
    thanks for suggestion

Posting Permissions

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