Re: app periodically stalls after executing sql for about a minute....
Hi Alex,
What is the effect if you in Tool Properties and in the SQL Commander / Result Sets category, check "Make Result Sets Read-Only" and then re-run the query?
Regards
Roger
a
anonymous
said
almost 11 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: app periodically stalls after executing sql for about a minute....
Roger
I turned on the +Make Result Sets Read-Only,+ ran a few queries, some at the same time -- no issues found.
Roger Bjärevall
said
almost 11 years ago
[This reply is migrated from our old forums.]
Re: app periodically stalls after executing sql for about a minute....
Hi,
Just so I get it, with "no issues found" you mean it runs faster with read-only result sets?
Regards
Roger
a
anonymous
said
almost 11 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: app periodically stalls after executing sql for about a minute....
Sorry, i meant runs with no noticable difference.
Roger Bjärevall
said
almost 11 years ago
[This reply is migrated from our old forums.]
Re: app periodically stalls after executing sql for about a minute....
Hi Alex,
I assume the Schema drop-down in the SQL Commander is empty while you are executing the query? If that is the case what happen if you set it to the appropriate schema and re-run the query?
Regards
Roger
a
anonymous
said
almost 11 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: app periodically stalls after executing sql for about a minute....
Roger
The schema was set to dbo, i believe..
Roger Bjärevall
said
almost 11 years ago
[This reply is migrated from our old forums.]
Re: app periodically stalls after executing sql for about a minute....
Alex,
Would be super if you can give it a try having the schema drop-down set along with the debug mode enabled. Please post the output.
Regards
Roger
a
anonymous
said
almost 11 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: app periodically stalls after executing sql for about a minute....
What should the schema mode be set to?
Roger Bjärevall
said
almost 11 years ago
[This reply is migrated from our old forums.]
Re: app periodically stalls after executing sql for about a minute....
Alex,
The schema should be set to match the schema in which the tables in the query reside.
Regards
Roger
a
anonymous
said
almost 11 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: app periodically stalls after executing sql for about a minute....
98% of the time i login as dbo.. so the schema is set to dbo .. is that ok ? and my debug log is always enabled
a
anonymous
said
almost 11 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: app periodically stalls after executing sql for about a minute....
Re: app periodically stalls after executing sql for about a minute....
Hi Alex,
This is a mystery. Do you have your DbVisualizer settings (preference directory) on a remote host? Is the connection to the database over a network that may be slow or unstable?
Best Regards,
Hans
a
anonymous
said
almost 11 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: app periodically stalls after executing sql for about a minute....
Hans
This is my .vmoptions file: (my C drive is a solid state drive)
+-Xmx1200m+
+-Ddbvis.prefsdir=C:\DEV_APPS_SETTINGS\dbvis+
+-XX:MaxPermSize=192m+
+-Dsun.locale.formatasdefault=true+
Product: DbVisualizer Pro 9.1.6
Build: #2117 (2014/01/26 21:20)
Java VM: Java HotSpot(TM) Client VM
Java Version: 1.6.0_65
Java Vendor: Sun Microsystems Inc.
OS Name: Windows 7
OS Arch: x86
OS Version: 6.1
May be its worth adding more debug lines around those functions that seem to sporadically cause this?
Its not really a big issue, just annoying :)
Hans Bergsten
said
almost 11 years ago
[This reply is migrated from our old forums.]
Re: app periodically stalls after executing sql for about a minute....
Hi Alex,
Thanks, so your "prefsdir" location should not be an issue but you didn't answer my question about the database and the network you connect to it over.
Good to know it's not a major problem for you.
Best Regards,
Hans
a
anonymous
said
almost 11 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: app periodically stalls after executing sql for about a minute....
Sorry, I overlooked that.
No, network slowness and db performance is not obesrved at all. All other apps are functioning normally...
anonymous