Question: What's new in Foxhound Beta 1.3655?
Answer: There is improved support for shared global temporary tables in the Display Schema function, including the Facts & Figures section.
There is improved support for materialized views in the Display Schema function. In particular, row counts, space usage and bytes per row are displayed for materialized views, and
CREATE INDEX and ALTER MATERIALIZED VIEW statements are generated where necessary to fully describe materialized views.
The DESC column sort order is displayed in FOREIGN KEY and UNIQUE constraints, in the Display Schema function.
A bug in the Monitor Database function was fixed, whereby repeated failed attempts to connect to multiple unavailable databases
would not be handled properly. Eventually, one of those repeated attempts to connect might succeed in connecting to the wrong
database, and the monitor would start sampling that database, instead of continuing to fail to connect to the unavailable database.
The standard Start Foxhound via Firefox and Start Foxhound via IE shortcuts no longer check to see if the dbeng11.exe
command worked, nor do they PAUSE or display error messages, before proceeding to display the Foxhound main menu page
in the browser. In most cases dbeng11.exe fails because the Foxhound database engine is already running and the PAUSE
and error message are simply annoying. If you are actually having problems starting the Foxhound database engine and want
to see what's happening, try using one of the "debug" shortcuts: Foxhound - Tools - Start Foxhound via Firefox - debug
or Start Foxhound via IE - debug.
The dbeng11.exe -qi option was added to the Start Foxhound via Firefox and Start Foxhound via IE shortcuts, as well as the
Foxhound - Tools - Start Foxhound Engine shortcut:
-qi tells the Foxhound database engine to "operate quietly": no system tray icon or console window.
this option was not added to the "debug" shortcuts, so you will see the icon and the console window if you use
Foxhound - Tools - Start Foxhound via Firefox - debug or Start Foxhound via IE - debug.
The dbeng11.exe -sb 0 -xd options were added to all shortcuts which start the Foxhound database engine:
-sb 0 and -xd reduce the likelihood that the Foxhound database engine will accidentally act as a "default server" or make
any attempt to accept unauthorized database connections... only HTTP connections are expected during normal operations.