View Issue Details

IDProjectCategoryView StatusLast Update
0001453Database Workbench v5Visual Query Builderpublic2017-04-18 13:25
ReporterMichael Vilhelmsen Assigned ToMartijn Tonies  
Status closedResolutionfixed 
PlatformAll over :)OSEverythingOS VersionAll versions
Product Version5.2.6 
Fixed in Version5.3.0 
Summary0001453: Create setting for Visual Query Builder to ignore stored routines (can take long in Firebird/InterBase)
DescriptionWhen I am entering an SQL, and press the VISUAL QUERY BUILDER it takes forever on some database before I'm in and can start working ... Why is that? And whats DBW doing?

Answer from youself via skype:
to start VQB it needs to fetch tables, views and selectable stored procedures. In order to figure out if a stored procedure is "selectable", it needs to check for SUSPEND in the source. Fetching source and routine parameters for all routines probably takes some time.
Steps To ReproduceJust do it :)
Additional InformationIt would be nice, if there where a setting, so I could let DBW ignore stored procedures.
I use those very seldom.
TagsNo tags attached.


Martijn Tonies

2017-03-31 11:28

administrator   ~0000413

Specifically in InterBase and Firebird this can take a long time. Other systems don't have this issue.

1) create Preferences setting under VQB: 'include stored routines'
2) create setting for each registered IB/Fb database with option values: application default/include/ignore

Issue History

Date Modified Username Field Change
2016-11-23 13:16 Michael Vilhelmsen New Issue
2016-11-23 13:19 Martijn Tonies Assigned To => Martijn Tonies
2016-11-23 13:19 Martijn Tonies Status new => acknowledged
2017-03-31 11:28 Martijn Tonies Note Added: 0000413
2017-03-31 11:28 Martijn Tonies Severity minor => tweak
2017-03-31 11:28 Martijn Tonies Status acknowledged => assigned
2017-03-31 11:28 Martijn Tonies Summary Opening Visual Query Builder takes a long time => Create setting for Visual Query Builder to ignore stored routines (can take long in Firebird/InterBase)
2017-03-31 14:14 Martijn Tonies Status assigned => resolved
2017-03-31 14:14 Martijn Tonies Fixed in Version => 5.3.0
2017-03-31 14:14 Martijn Tonies Resolution open => fixed
2017-04-18 13:25 Martijn Tonies Status resolved => closed