[This topic is migrated from our old forums. The original author name has been removed]
-- DbVisualizer 9.1.10
Hi all,
I'd like to have your feedback on how to improve the SQL statement execution and/or how to pinpoint the 'bottleneck' in the execution time?
I'm using this tool to connect to a Sybase ASE server using 'Sybase ASE (jTDS)' driver. The driver I'm using is the one coming with the application.
I noticed that most of my queries are slower using DBVis compared to other tool like sqsh/
select colA from tableA where colB=
with sqsh the execution timing is
Clock Time (sec.): Total = 0.011 Avg = 0.011 (94.66 xacts per sec.)
while with DBVis, it took about 5s.
Before moving to another tool, I'd like to find out where the differences come from and potentially how to fix it.
Thanks all for your help and merry christmas
Simon
Simon,
Can you please run the query again with Debug DbVisualizer enabled in Tools->Debug Window? Post the debug output here or email to support@dbvis.com.
Regards
Roger
a
anonymous
said
almost 10 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Simon,
Sorry for the delay.
It seems that the database call to fetch the columns for the table is taking much of the time.
Testing this with the jConnect driver from Sybase would indicate whether it is a driver issue or on the DB side.
Regards
Roger
anonymous