From: Colin Bell <Colin.B<ell@as...> - 2003-10-20 03:11:10
Thanks for these. I'm putting out beta4 either tonight or tomorrow night so
as soon as I do that I'll look at your changes.
> -----Original Message-----
> From: Keith Mashinter [mailto:keith.mashinter@...]
> Sent: Monday, 20 October 2003 6:47
> To: squirrel-sql-develop@...
> Subject: [Squirrel-sql-develop] diffs for additional configuration
> settings to improve load/execute performance over slow networks
> Colin, here is another change to allow you to disable the
> loading of schema/object information and also to disable
> loading metadata for result sets. This really improved
> response time over the VPN to our client and make remote
> support easier to their DB2 database, while we normally run
> on Oracle. I've ran the diff from cvs as you suggested. I
> made the changes based on 1.2beta3 as opposed to the latest
> source but you should be able to filter out my changes from
> the others. Thanks.
> This change to squirrel-sql 1.2beta3 adds configuration settings:
> o Session / General / Load Schema MetaData
> o turn off to save time by not loading schema
> o Session / General / Limit Schema Objects
> o use comma-delimited prefixes to limit the display of
> schema objects
> o Session / SQL / Load SQL Results MetaData
> o turn off to save time by not loading MetaData for SQL results
> Turning these features off can improve performance over a
> slow network.
> The diff from the latest CVS in the attached diff-km.txt
> indicates there
> have been other changes since the changes were made to the
> beta3 release.
> The changes I made are related to the fields noted below.
> SessionProperties (drives changes in other files):
> public String splitString(String str, char delimiter,
> boolean removeEmpty)
> The last method mentioned could be refactored to a general
> static StringUtils class.