View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000246 | Database Workbench v6 | Firebird Module | public | 2012-01-30 09:47 | 2022-01-12 13:18 |
| Reporter | Thomas Steinmaurer | Assigned To | |||
| Priority | normal | Severity | feature | Reproducibility | always |
| Status | acknowledged | Resolution | open | ||
| Summary | 0000246: Support for page buffers and no garbage collection DPB options | ||||
| Description | There are two interesting database parameter blocks in the Firebird client api available, which would be useful to have it supported by DBW: 1) Temporary cache buffer: While there is a page buffers value stored on the header page of a Firebird database, which defines RAM usage for the page cache, the Firebird client API allows to specifiy a temporary page buffers value at connect time, temporarily overriding the persistent page buffers value for this particular connection/session. I'm using that sometimes with Ivan's "fsql" command-line utility and find that handy, if I could use DBW in this scenarios as well. The DPB is called: isc_dpb_num_buffers 2) Omit garbage collection: Another database connection level API option is to omit garbage collection. Especially useful for Classic and SuperClassic server, where the cooperative GC can slow down statements, as they are directly responsible for removing garbage. I would find it useful if I can run statements in particular scenarios without GC involved, especially during development to measure pure execution time without GC etc. The DPB is called: isc_dpb_no_garbage_collect If you add support for that in DBW, I guess it would make sense in the database registration dialog and in the Connect As dialog. | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-01-30 09:47 | Thomas Steinmaurer | New Issue | |
| 2012-01-30 10:16 | Martijn Tonies | Status | new => acknowledged |
| 2013-09-11 16:06 | Martijn Tonies | Project | Database Workbench v4 => Database Workbench v5 |
| 2022-01-12 13:18 | Martijn Tonies | Project | Database Workbench v5 => Database Workbench v6 |
