SpeedQuel: Oracle Development & Support

Stay up to date!

Back to main SpeedQuel page.

SpeedQuel - Change History

SpeedQuel v2.04 (20/03/2010)

Increased number of tabs from 100 to 200
Fixed crash bug when parsing a / on a long line
Fixed format of query with ) in line comments
Fixed cancel query not clearing status of session and making it unuseable
Fixed cursor display on lines with &
Enhanced format query to handle ANSI syntax

SpeedQuel v2.03 (08/01/2010)

Complete custom rewrite of query editor:
- HUGE performance improvements across the board, especially with larger files
- Reduced memory usage
- Undo/Redo finally works!
- Improved SQL and unnamed PL/SQL block parsing
- Improved syntax colour highlighting
- Bracket scope highlighting
- Current query under cursor highlighting
Format Query improvements (now handles all other statements, eg update, insert, delete, with)
Started some memory usage tracking (via Help > About)
Fixed Save As CSV/Text bug with LOB columns
Fixed problem with cancel query sometimes ignoring the request
Fixed several miscellaneous and hard to reproduce crashes and memory leaks

SpeedQuel v2.02 (27/06/2009)

Various version number formatting changes to match new style
Query Tab line numbers now look different for unnamed PL/SQL blocks
Fixed some issues with parsing unnamed PL/SQL blocks within Query Tabs
Fixed various issues with DEFINEd variables
Fixed population of recent sessions/scripts/workspaces and keyboard shortcuts for new installations
Spooling to CSV files now appends each new statement instead of overriding any existing file
Added Format Query (Ctrl+M) context menu to provide simple SQL formatting
Creates ERRORLOG.TXT if it crashes, please send this to us
Can now disable DEFINEd variables via SET DEFINE OFF
Change to focus handling where a script full of fast queries would keep stealing focus away from other tabs

SpeedQuel v2.01 (31/05/2009)

This is a complete rewrite of SpeedQuel with a new user interface and new and improved features! The full list of changes is enormous (18 months of hard work!), so a brief summary of enhancements is:

Completely new redesigned GUI
- Modern look and feel
- Dockable/customisable toolbars
- Dockable session bar - any edge or floating
- More flexible output windows - up to 5 at once!
- Choose from several colour themes
Master Tabs provide tab grouping capabilites to help fit large workspaces on screen.
A huge number of performance and resource consumption improvements, despite the GUI enhancements SpeedQuel v2 is even leaner and faster than v1 was!
Additional Oracle data type formats supported (vastly improved support for LOB and LONG datatypes!)
Now works with multiple Oracle homes and the Oracle Instant Client.
RAC aware - supports automatic failover (TAF), connect to specific instances (even without a dedicated service defined), displays currently connected instance, and more.
Improved performance tuning feature set (better query parsing capabilities for gathering tuning info, better support for partitioned objects, parallel query execution, and more).
Completely redesigned Browser Tab for better multi-threading and useability.
New simplified licensing model.

SpeedQuel v1.1.3 - 03/11/2007

Several enhancements to PL/SQL and Schema Browser GUI
Enhancement to the logon dialog - the saved sessions are now coloured according to the security config
Enhanced compiling of PL/SQL objects to fully support all legal Oracle syntax
Now automatically attempts to reconnected dropped sessions (e.g. if database has been restarted)
Miscellaneous other GUI enhancements and smarter error handling
Fixed calculation of table sizes > 2 GB in Tuning Info
Fixed issue with bind variable dialog - now correctly updates entered value
Fixed bug with the show view command for views with exactly 30 chars
Fixed display of PL/SQL compile errors
Fixed crashing bug with highlighting PL/SQL compile errors on lines < 4 chars in length

SpeedQuel v1.1.2 - 29/04/2007

Fixed drawing problem when creating new pl/sql tab in multiline workspace
Improved error handling when running out of memory with very large result sets
Fixed find/replace error which recursively replaced text if find text was within replaced text!
Performance improvement for find/replace

SpeedQuel v1.1.1 - 26/01/2007

Fixed bug with LONG datatypes where fields had > 16k of data
Added commit/rollback toolbar buttons
Fixed bug with proxy authentication
Fixed bug with logon dialog corrupting saved connection details
Misc GUI enhancements and fixes

SpeedQuel v1.1.0 - 07/01/2007

Now automatically runs dbms_output.enable() for new sessions (configurable in general options)
Improved performance of plan/tune tabs (query + draw)
Now marks tab dirty after find/replace is used
Huge performance improvements for resizing the dialog
Fixed cancelling query issue
Fixed several tab redraw problems
Fixed text cache problem after find/replace is used
Fixed drawing problems with tabs/session bar
Reduced flicker on query text/output tab contents
Reduced toolbar flicker
Other misc GUI enhancements

SpeedQuel v1.0.4 - 18/11/2006

Schema Browser enhancements
Enabled ignore errors options on script error dialog
Prevented some hanging problems with misuse of session bar
Fixed some syntax highlighting problems
Fixed some small memory leaks
More exception handling
Misc GUI enhancements and user feedback

SpeedQuel v1.0.3 - 27/10/2006

Added field data dialog
Improved mixed SQL + PL/SQL handling
Improved grid zooming and column sizing
Redesigned the options pages
Fixed some bugs with handling LOB datatypes
Fixed some small memory leaks
Fixed crashing bug with eval dialog
Fixed problem with installation wizard not upgrading old installs
Misc GUI enhancements

SpeedQuel v1.0.2 - 16/10/2006

Major GUI improvements
Added warn DDL/DML to session rules config (doesnt reuse config from older versions)
Changed default left output width to 100%
Fixed website link on new version detected dialog
Fixed bug in calculation of the sum of highlighted cells

SpeedQuel v1.0.1 - 25/09/2006

Added MRU list of sessions with saved passwords from toolbar button (DBA release only)
Added fetch stop count parameter to automatically stop fetching queries after a specified count
Added proxy server authentication capability for detecting new versions
Enhanced toolbar and sessionbar handling (dragging, resizing etc)
Changed text highlighting method (Shift+Ctrl+Left/Right) to be more standard
Fixed crashing bug with bind variable detection
Fixed scroll bars on zoomed grids

SpeedQuel v1.0.0 - 16/09/2006

Fixed F6 script runtime calculation
Fixed bug with cancel script
Misc GUI enhancements

SpeedQuel v0.3.9 - 10/03/2006

Added proxy server support for checking for new versions
Fixed ordering of logon times in logon dialog
Fixed several PL/SQL compiling issues
Fixed annoying backup error for new files
Fixed DESC whitespace parsing issue
Yet more GUI enhancements/fixes
Reverted to old compiler due to too many nagging issues with the new one!

SpeedQuel v0.3.8 - 05/02/2006

Fixed bug with cancelling queries
Fixed save workspace bug
Fixed bug with Duplicate Session
Some Schema Browser improvements
Misc GUI enhancements (notably status bar, resizing issues, schema browser interaction)
Compiled with a new compiler (installs new MFC dlls now)

SpeedQuel v0.3.7 - 17/01/2006

Added Find/Find Next/Replace/Replace All functionality
Added DEFINE and UNDEFINE statements to handle script substitution variables (eg DEFINE var=value and reference with &var)
Added options to automatically backup scripts and workspaces prior to saving
Many GUI improvements - including visual identification of dirty tabs and left/right activation status
Cancelling queries is now done in a new thread (some Oracle operations dont break immediately) and several deadlocking issues fixed
Added partitioning columns to explain plan where available and applicable
Improved stability and error handling
Fixed several script parsing issues
Fixed several small memory leaks
Fixed bug with running super long statements

SpeedQuel v0.3.6 - 18/12/2005

Added Reconnect and Duplicate session menu items
Fixed intermittent F5 script parsing issue
Fixed intermittent PL/SQL script parsing issue
Fixed intermittent bug with show tuning info when referencing views
Improved PL/SQL highlighting of compilation errors
Improved speed of statement parsing for huge scripts
Misc GUI fixes and enhancements

SpeedQuel v0.3.5 - 11/12/2005

Added auto detection of new version and enabled Check for Updates menu item
Partial support for mixed PL/SQL and SQL code in Query Tabs, and now accepts / on a new line as a query delimiter
Ignores ORA-24347 warning
Rewrote syntax highlighting code - should perform faster, more accurately now and with less flickering
Fixed logon screen bug
Fixed copying cells containing large LOBs

SpeedQuel v0.3.4 - 04/12/2005

Added parameters to control automatic loading of each schema object type
Major enhancements to Browser Tabs
Added Show Line Numbers for Query Tabs and PL/SQL Tabs
Added support for CLOB and BLOB datatypes
Can now drag tabs to new positions
Added Skip Scans to highlighted plan operations
Logon screen shows Last Logon using Windows Locale settings and sorts most recent correctly now (from now on existing entries will not display correctly)
Logon screen - context menu options are now functional
Logon screen - new option to not save any details
Fixed grid selection calculation with zoomed grids
Fixed saving of parameters for default width and height of Query Tabs
Fixed error with running large queries with bind variables
Fixed error with F6 and certain cursor placements
Removed F3 and F4 keys for login/disconnect - too easy to accidentally disconnect a session
Other misc GUI fixes

SpeedQuel v0.3.3 - 13/11/2005

Rewrote Schema Browser
Improved PL/SQL compiling
Improved toggle case
Misc GUI improvements/fixes/speedups
Installer - No longer overwrites license info, Added WKS file association

SpeedQuel v0.3.2 - 07/11/2005

Added toggle case
More work on PL/SQL tabs - can now compile and shows errors
Misc GUI and refreshing fixes

SpeedQuel v0.3.1 - 30/10/2005

Added support for command line parm - allows either a workspace or normal file to open
Started to add PL/SQL Tab sheets for compiling PL/SQL code
Toolbars can now be resized
Changed tabbing - Pg Up/Down scrolls through sequentially, Ctrl+Tab now scrolls through a history of tab selections
Shift+Tab now moves the selected cell left in the grid
Added Help>Kimien Software Website
Fixed bug with F5/F6 script parsing if cursor was not on first statement!
Fixed issues with running queries with bind variables - now executes sql with bind vars and uses correct execution plans
Fixed some multithreading issues highlighted when the Scheduler runs very fast
Fixed some miscellaneous GUI issues

SpeedQuel v0.3.0 - 21/10/2005

Added script scheduler for each query tab (DBA Release).
Spool command will now spool to CSV files automatically if the filename ends with .CSV
Reversed order of Log entries so most recent is at top, and it now truncates old lines when there are too many.
Fixed Explain Plan support for v8 databases
Fixed Tune Info support for v8 databases
Fixed Tune Info slow/accurate version
Fixed horizontal scrolling issues with Query Tab's text

SpeedQuel v0.2.12 - 24/08/2005

Added new Run Current Statement With Stats and took out auto stats collection from F7
New keys: F3 (connect), F4 (disconnect), F7 or Ctrl+Enter (run current statement without stats), F8 or Ctrl+Shift+Enter (run current statement with stats)
GUI fixes & enhancements

SpeedQuel v 0.2.11 - 23/08/2005

Added option to show tabs on one line
Fixed issue with tuning info and duplicate tablenames across schemas
Fixed bug with disconnecting from Session Bar when many sessions open. Increased max sessions from 10 to 50 for DBA Release.
Several GUI fixes & enhancements

SpeedQuel v 0.2.10 - 14/08/2005

Added SHOW VIEW xxx command to list the contents of a view
DBMS Output tab now works
Added option to display logon screen on startup
Ctrl+H,U will hide/unhide the right output
Tuning info now looks inside views for base tables
DESC now works properly with synonyms
No longer errors when selecting LONG RAW, BLOB or CLOB data types
Misc GUI fixes/enhancements

SpeedQuel v 0.2.9 - 09/08/2005

Fixed tune info difference calculation (and includes Bytes field)
Most DDL statements now clear dirty status of sessions
Ctrl+1,2,3... will switch the current tab's session to the appropriate session
Added SHOW PARAMETER[S] xxx command
Added SHOW SGA command
Auto change to Results tab when start to fetch rows
New workspace file format - saves links to any .sql files opened within the workspace, and saves browser tabs (cant open old workspaces, sorry!) If you really need to convert just put an extra number 0 after each tab name. eg: Running SQL,34.1,100.0,20 becomes: Running SQL,0,34.1,100.0,20
Tuning info now includes table info even if it doesn't have any indexes

SpeedQuel v 0.2.8 - 07/08/2005

Misc GUI fixes/enhancements
Fixed yet another workspace saving issue
Fixed drawing of last line in grids
Improved session handling for tabs

SpeedQuel v 0.2.7 - 02/08/2005

Misc GUI fixes/enhancements
Fixed querying LONG fields
Fixed intermittent cancel bug
Fixed several workspace related issues (saving newlines, marking dirty, redraw)
Fixed hanging when changing options while query is running

SpeedQuel v 0.2.6 - 28/07/2005

Misc GUI fixes/enhancements
Fixed bug in saving workspace which forgets the path info
Added SET OUTPUT LEFT|RIGHT script commands

SpeedQuel v 0.2.5 - 27/07/2005

Misc GUI fixes/enhancements
Fixed undo/redo cache issue
Fixed ENTER from exiting application when focus was on various controls
Visual enhancements for output tabs/buttons
Browser tab enhancements
Fixed cancellation of long running DML queries
Grid enhancements - alternate line colours (configurable) and the grid is now zoomable!

SpeedQuel v 0.2.4 - 19/07/2005

Fixed cancelling of tune/plan
Improved screen redraw when under high load
Added visual indicator to Session Bar for sessions that are running statements
Misc GUI fixes
Fixed save workspace bug?
Started Schema Browser tab
Fixed issue with Ctrl+Backspace/Delete not updating query cache

SpeedQuel v 0.2.3 - 13/07/2005

Fixed crashing bug when cancelling scripts multiple times
Fixed stalling bug when cancelling a statement still in the execution phase
Yet more improvements to syntax highlighting
Script turns read only when using F5 or F6 to avoid alot of potential issues
Ctrl+Backspace and Ctrl+Delete now clear one word at a time
Misc interface enhancements
Improved Undo/Redo
Improved running with bind vars dialog (still has issues though)
Now remembers last open window coords/state

SpeedQuel v 0.2.2 - 10/07/2005

Fixed bugs in cancel query
Fixed several seemingly random multi-threading related bugs
Further improvements on syntax highlighting speed and accuracy
Fixed issues with DELETE key
Fixed double click highlighting

SpeedQuel v 0.2.1 - 06/07/2005

Misc GUI fixes/enhancements
Toned down evaluation nagging a bit
Added logging capability (enabled by useLog = 1 registry entry)
Moved registry entries under Kimien folder

SpeedQuel v 0.2.0 - 04/07/2005

Added evaluation release support, and fixed some other licensing issues
Create Insert Values now works for all highlighted rows
Significant syntax highlighting performance and accuracy improvements (still too slow though!)
Tuning info now works with update, delete and insert statements
Misc GUI touch ups and bug fixes

SpeedQuel v 0.1.12 - 20/06/2005

Improved accuracy of identifying query bounds
Fixed bug with SQL stats not being collected after running a script (and only collects for F7 now)

SpeedQuel v 0.1.11 - 19/06/2005

Misc cosmetic fixes
Fixed bug with SQL stat figures from v0.1.9
Rewrote query recognition - faster and more accurate
Improved performance of syntax highlighting
Fixed bug with saving encrypted passwords
Fixed paragraph formatting issues with pasting text
Some Edit menu options now work (Undo/Redo/Cut/Copy/Paste/Delete/SelAll/Comment/Uncomment)
Fixed crashing bug in session color options
Can now run statements using bind variables - very useful in performance tuning
Fixed intermittent ORA-1403 error when running scripts
Fixed some small memory leaks
Added toolbar buttons for cut/copy/paste/connect/disconnect
Added MRU list for scripts and workspaces
Added Copy Plan/Copy Tune Info menu options
Installer now creates shortcuts and uninstalls older versions

SpeedQuel v 0.1.10 - 08/06/2005

Fixed crashing bug when no rows returned
Fixed crashing bug with right click on sessions config list
Improved error messaging
Fixed Run Script from Cursor

SpeedQuel v 0.1.9 - 05/06/2005

Tweaked dynamic fetch sizes at low and high ends
Misc user prompts
Save as Text file in grid
Added the SQL*Plus SPOOL command for logging results to a text file
Changed default Open command to use new tab instead of current tab
Fixed display of ROWID datatype fields
Running scripts now scrolls the screen as it runs through the queries
Added SET IGNORE ALL|NONE|942 950... command to prevent errors from appearing when running scripts
Fixed overflow bug with fetching calculated numeric fields
Drastically reduced memory footprint
Fixed some small memory leaks
Added block comment/uncomment (Ctrl+- and Ctrl+Shift+-)
Fixed issue with editing files > 32KB

SpeedQuel v 0.1.8 - 01/06/2005

Fixed bug with sorting stats results
Several major performance tweaks, including copy selection
Running scripts now logs results in the Log tab
Cleaned up query selection a bit (doesnt grab comments before query)
Rewrote OCI fetching for more efficiency and simplicity
Now correctly displays RAW datatypes (eg v$session)
Fixed up column resizing and highlighting issues
DESC[RIBE] now works for views and synonyms as well as tables
Synchronize Vertical Scrollbars button now works
Added the SQL*Plus EXEC[UTE] for PL/SQL commands
Preparation for running with binds and editable grids

SpeedQuel v 0.1.7 - 31/05/2005

Fixed some grid scroll related drawing problems
Misc cosmetic enhancements
Several performance tweaks

SpeedQuel v 0.1.6 - 25/05/2005

Fixed grid drawing bug in release ver
Fixed selection bug in logon dialog
Fixed bugs with saving workspaces
Fixed some drawing problems with the Session Bar
Fixed some drawing problems with new tabs
Ctrl+Shift+L/R now works properly
L or R Ctrl+Shift+PgUp/PgDwn now changes tabs on left/right output
Shift+moving around grid highlights multiple cells
Fixed some flickering problems with the grid

SpeedQuel v 0.1.5 - 22/05/2005

Fixed bug with encrypting passwords
Fixed many issues with scrolling of grids
Highlighting on header rows/cols of selected cells
Manual resizing of grid columns
Grid context menu
Create Insert Values
Grid context menu
Copy Selection/All/Titles
Grid context menu
Save as CSV
Other cosmetic enhacements

SpeedQuel v 0.1.4 - 19/05/2005

Fixed bug with drawing on completion of plan or tune
Fixed horz scroll range calculation bug
Started bind variable dialog
Created kick ass logon screen
Right click on multi-column tree controls now select item properly
Can now connect as sysdba and as sysoper
Fixed bug with sticky Ctrl key
Fixed exit crash bug
Fixed focus settings on options dialog
Parameterised default width and height of new tabs

SpeedQuel v 0.1.3 - 11/05/2005

Register license code screens
Fixed bug with copy selected cells
Fixed bug with open file with no tabs
Improved query scrolling
Fixed autosize to only shrink first displayed column if its too small, and to a >0 size
Fixed bug with moving output bar off end of screen
Ctrl+Left/Right now moves one word at a time
Prevented changing sessions while a query is running
Fixed bug with cancelling query script run via F5 or F6
Fixed flickering issue when running queries from workspaces with multiple rows of tab headers
Now inserts tabs/spaces to align text after pressing enter
Now uses default filename for save as and save workspace as

SpeedQuel v 0.1.2 - 10/05/2005

Fixed bug with update sum
Added Apply To All Tabs to sessionbar context menu
Moved logon screen to loop if errored
Fixed bug with index/outdent
Put filenames in tab name
Changes hide to unhide