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: rhill@hillconsult.com
To: squirrel-sql-users@lists.sourceforge.net
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
Squirrel-sql-users@lists.sourceforge.net
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 Squirrel-sql-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users