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