SpeedQuel - Change History

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

 

Copyright © 2009, Kimien Software. All rights reserved.