View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001453 | Database Workbench v5 | Visual Query Builder | public | 2016-11-23 13:16 | 2017-04-18 13:25 |
Reporter | Michael Vilhelmsen | Assigned To | Martijn Tonies | ||
Priority | low | Severity | tweak | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Platform | All over :) | OS | Everything | OS Version | All versions |
Product Version | 5.2.6 | ||||
Fixed in Version | 5.3.0 | ||||
Summary | 0001453: Create setting for Visual Query Builder to ignore stored routines (can take long in Firebird/InterBase) | ||||
Description | When 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 Reproduce | Just do it :) | ||||
Additional Information | It would be nice, if there where a setting, so I could let DBW ignore stored procedures. I use those very seldom. | ||||
Tags | No tags attached. | ||||
|
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 |
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 |