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

    Unanswered: performance time

    Hi,

    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
    Hari

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    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
    Posts
    8
    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
  •