Re: [Squirrel-sql-develop] diffs for additional configuration settings to improve load/execute perf
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Colin B. <col...@bi...> - 2003-11-01 22:53:01
|
On Mon, 2003-10-20 at 06:46, Keith Mashinter wrote: > 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. > Hi Keith, I'm looking at your patch now. Did you make a change to one of the session properties panels to configure the turning on/off of "Session / General / Load Schema MetaData"? I can't find it in your diff. -- Colin Bell http://squirrel-sql.sf.net |