Thread: RE: [Squirrel-sql-develop] diffs for additional configuration set tings to improve load/execute per
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Colin B. <Col...@as...> - 2003-10-20 03:11:10
|
Hi Keith, 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. Thanks Col > -----Original Message----- > From: Keith Mashinter [mailto:kei...@na...] > Sent: Monday, 20 October 2003 6:47 > To: squ...@li... > 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): > getShowResultsMetaData > getSchemaShow > getSchemaPrefixArray > SCHEMA_SHOW > SCHEMA_PREFIX_LIST > SHOW_RESULTS_META_DATA > _schemaShow > _schemaPrefixList > _showResultsMetaData > public String[] splitString(String str, char delimiter, > boolean removeEmpty) > > The last method mentioned could be refactored to a general > static StringUtils class. > > SessionSQLPropertiesPanel: > SHOW_RESULTS_METADATA > _showResultsMetaChk > |