Re: [Squirrel-sql-users] Building Output extremely slow accessing iSeries table
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Jim It <ji...@ho...> - 2012-07-26 20:05:50
|
There are a few properties which can help. iSeries Driver properties in Alias properities Block Size = 256 Data compression = True Extended MetaData = False Global Preferences - General Save Preferences Immediately = unchecked. New Session Properities - SQL Limit SQL History Combo Size - Smaller is faster. Jim Date: Wed, 25 Jul 2012 19:00:24 +0100 From: rh...@hi... To: squ...@li... Subject: Re: [Squirrel-sql-users] Building Output extremely slow accessing iSeries table For what it is worth, I see exactly the same effect on iSeries running V6R1. You get used to it. Roger On 25/07/12 17:06, Robert Rogerson wrote: Hi all, I have checked the documentation and googled for a solution/advise but not found any. I have just started using Squirrel 3.3.0 with the intention of replacing iNavigator's Run SQL Scripts. I am accessing DB2 on an iSeries at V7.1 The biggest problem I have experienced is it takes over 30 seconds to return a query. The status bar tells me "Query 1 of 1, Rows read: 100, Elapsed time (seconds) - Total: 45.186, SQL query: 0.577, Building output: 44.609" The the query is a simple SELECT * FROM mytable. I have read that the number of columns returned slows down execution. What I'd like to know is there a way of limiting the Building Output step. One thought was to only return the Results tab not the MetaData, Info and Overview tabs, but I have been unable to find how to turn these off. Any help would be appreciated. I am impressed with this tool but if a simple query takes over 39 to return I don't think it will be of use top me. Thanks, Robert Rogerson ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |